What's the best way to bring back a record on a form?

[rodneyb]

Hi,

I have been asked to create a form that just has a field where the user enters in a unique id and the details for that record is displayed on the form - the user can then update a field for this record and commits to the table.

I'm just trying to figure out what is the best way to do this? Do I base the form on the table being queried or do I just set up an unbound field and do some code behind it to do the query and update?

Any suggestions much appreciated.

 

[missinglinq]

Base your form on a query that shows the record fields that you want to display. Place a combobox on the form. The Access Wizard will ask you what you want to do with the combobox value. The third choice is something like "Find a record on my form based on the value I selected". Select this, click "Next", and choose the field that contains the unique ID you're using. Follow the wizard's instruction (I think you just click "Finish" to complete it).

Hope this helps.

The Missinglinq

 

[rodneyb]

great! just what I wanted.

Thanks Missinglinq.

 

[dat_guy]

tag