Creating form from database help

[rponto2013]

I want to create a form that will be filled in when a use selects an item from a alphabetical dropdown box in the form. I also want to be able to update the database that the form draws from; so when the user wants to look up a product, up to date information is available. I have access 2010 at home and 2007 at work. I also have the new 2013 but have not tried using it yet.

[June7]

What do you mean by 'filled in' - move to an existing record? Here is one method http://datapigtechnologies.com/flash...tomfilter.html

And by 'update the database' do you mean 'update the table'?

Building forms bound to tables is basic Access functionality and guidelines are in Access Help.

Data entry/edit on bound forms will pass the data directly to the table.