new at this..

[sharonir22]

I have a database of names and id numbers.
I created a form with a dropbox containing all the ids in my database.
I also have a form with all the fields in my database which is supposed to allow me to edit my records.


what do I need to do so when I select an id from my dropbox a form opens allowing me ro edit the record I chose?

*it always opens the form on the first record in the table [emoji20]

[June7]

Can use the intrinsic Access search/filter tools. Alternatives require code (macro or VBA).

Review:

http://datapigtechnologies.com/flash...tomfilter.html

http://www.allenbrowne.com/ser-62.html

The combobox used to input/select filter criteria must be UNBOUND.

[ranman256]

I have a single rec form. the query shows all records. The list box shows all records.
When I click the list box , it will then filter that ID.

me.filter = "[clientID] = " & lstClient
me.filterOn = true

I also have an Alphabet filter, to filter the lstClients by Last name when clicked.

[sharonir22]

I would really appreciate dumbed down and detailed answers.. I've just started experimenting in access

[June7]

What exactly do you not understand about intrinsic tools?

What exactly do you not understand about the DataPig video?

Granted, the Allen Browne tutorial is a little advanced but has step-by-step instruction.

Here's another method http://www.dummies.com/how-to/conten...cess-2013.html

Use the Control Wizard when creating combobox and it will build embedded macro search code for you.

You will have learn about options and do a lot of experimenting to find what works best for you. We don't know your db and requirements so can't give specific guidance. Learn concepts and apply as appropriate.