I am trying to get my form to bring up a certain record based on a combo box. The combo box's list is based on a query that is filtered based on data typed in to several control text boxes. I got the combo box to bring up the PK of the record that I want to edit but it won't move that that record.
I tried to use the Goto Record function but don't know how to go to a certain recorded based on the PK. The Record Number doesn't equal the PK Number. So record 5 isn't PK 5.
I can't seem to figure out the Find Record function so it will look up the PK in the table that is selected.
So I need to have the form pull up the record from the table dbo_Transactions using the selected number in the combo box dbo_Transactions_ID on the form Transactions - Time Change using the PK ID of the table dbo_Transactions.
Table: dbo_Transactions
Table PK: ID
Form: Transacions - Time Change
Combo Box Control: dbo_Transactions_ID
Hope I explained that correctly and clearly enough.
Thanks for your help
I tried to use the Goto Record function but don't know how to go to a certain recorded based on the PK. The Record Number doesn't equal the PK Number. So record 5 isn't PK 5.
I can't seem to figure out the Find Record function so it will look up the PK in the table that is selected.
So I need to have the form pull up the record from the table dbo_Transactions using the selected number in the combo box dbo_Transactions_ID on the form Transactions - Time Change using the PK ID of the table dbo_Transactions.
Table: dbo_Transactions
Table PK: ID
Form: Transacions - Time Change
Combo Box Control: dbo_Transactions_ID
Hope I explained that correctly and clearly enough.
Thanks for your help