In Access, showing a table field value in a form field?

[Ovatvvon]

I'm creating a small inventory database for office supplies. I want to be able to interact with the db from a form within access.

I have designed the form to have fields such as nomenclature, description, etc.

I'm having trouble having the form take data from the table on a specific record and entering it into the form textbox automatically.

How can I have it do this...say from record two or four or whatever? (I'll create the search box so they can enter whatever ID they want to go to that specific record...right now I'm just having trouble writing up the correct code to have it display the fields I want from the table into the form fields)

-Ovatvvon :-Q

 

[Dreamboat]

Here's all you should need to do if you've created a form from the wizard FIRST:

http://www.theofficeexperts.com/access.htm#SearchForm

Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX