Query with criteria that is linked to the record that is showing on your form

[rosscortb]

Hello,

I have a simple query that pulls from two tables- Personal Details and Salary.



I also have a Personal Details form which I have placed a command button to run the query.

In the query I have set the criteria so that is shows the salary info based on the record that I am currently viewing in the Personal details form> [Forms]![PersonalDetails]![ID]

I have got this to work but only somes as when I click the command button to run the query it sometimes pops up with the criteria and I have to manually input the ID number, any ideas why this keeps happening?

Ross

[Bob Fitz]

Perhaps the control called [ID] has no value when this happens. This could be the case on a new record or one which has not yet been saved to the table.

[rosscortb]

Hi Bob,

Only got two records in the database currently.

Ross

[Bob Fitz]

Can you post a copy of the db for us to play with

[rosscortb]

Hi Bob,

Came in to work and opened and it seems to be working each time now. Thanks anyway.

Ross

[Bob Fitz]

Hi Bob,

Came in to work and opened and it seems to be working each time now. Thanks anyway.

Ross

Good Let us know if the problem reoccurs