Access Form Help

[John Evans]

Hello,

I have a form names Member DetailsUSR

When i open the form, i want to be prompted to insert the value of a form,
and then the record corresponding to the value entered will be displayed.

I managed to achive this, but then forgot how i did it.
There is an image below of what i mean.

http://img55.imageshack.us/img55/8906/imageat0.png

 

[MikeJohnB]

I think the easy way to do this is to add a combo box. With the form in
design mode drag a combo box from the tools menu, use the wizard, select the
option, "Find a record on my form based on a value I selected in my Combo
Box"

Follow The prompts

Select Fields
Adjust the Widow Size
Name the Combo Label
Press finish

Now you should be presented with a drop down box containing all the records
but you can just type a value in there and providing it is in the list, the
form will return all the details relating to the item selected.

Regards

 

[Tom Wickerath]

Hi Mike,

To add a little bit to your reply, here is an article I prepared on this
very subject:

Combo box to find a record
http://www.access.qbuilt.com/html/find_a_record.html


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[MikeJohnB]

Excellent Tom, I read the article, picked up a couple of tips also.

Kindest Regards

Mike B