Lookup Record

[Former Community Member]

I have created a form that coonects to an MS

Access Database and have created the standard set of buttons to navigate the records, but what I want to be able to do is either create a button or drop down list of client numbers and when the user selects the client number it then pre populates the form with the information.

[Niall_O_Donovan · Accepted solution]

Hi,

The best resource for databases stuff is Stefan Cameron's blog. Here are some links:

http://forms.stefcameron.com/2006/09/18/connecting-a-form-to-a-databas e/

http://forms.stefcameron.com/2006/09/29/selecting-specific-database-re cords/

http://forms.stefcameron.com/2006/12/18/databases-inserting-updating-a nd-deleting-records/

Hope that helps,

Niall

[Former Community Member]

Stephan Cameron has a blog entry about this:

http://forms.stefcameron.com/2006/09/29/selecting-specific-database-records/

paul