Good day, I'm rather new to Access and have been teaching myself by trying to make a book cataloging database. I have very little VBA knowledge, and so far the information in these forums has been a great help.
Recently I started using subforms. I have a parent form which contains all the information on the books, with the data stored in the table Items. I have added a subform which is a shortened datasheet of Items. I would like to be able to click on a record in the subform to make the parent go to that record.
I'm currently using a combo box to select records, but it doesn't provide the same filtering and sorting ability as a datasheet. All records have a ItemId which is created using an autonumber.
Any Advice or Suggestion would be extremely welcome.
Thank you
James
Recently I started using subforms. I have a parent form which contains all the information on the books, with the data stored in the table Items. I have added a subform which is a shortened datasheet of Items. I would like to be able to click on a record in the subform to make the parent go to that record.
I'm currently using a combo box to select records, but it doesn't provide the same filtering and sorting ability as a datasheet. All records have a ItemId which is created using an autonumber.
Any Advice or Suggestion would be extremely welcome.
Thank you
James