Gossamer Forum
Home : General : Databases and SQL :

about ms access forms

Quote Reply
about ms access forms
I can create an acess form which gets data from a table in my database. One sees the records on the formone by one by using the browse button, which only shows the records one after another.

How can I do it such that the user types the name or number of a peron's record and clicks a button, and the form jumps to the reqired record.
Quote Reply
Re: [donbes] about ms access forms In reply to
Hello,

In regards to your question.........

Make a Query based on the table with your data, then open the query and within the field place the criteria that you are looking for........

Such as LIKE[ENTER NAME]
or whatever it is that you use to id the persons record,
Then you can simply make a report based on this query ...


Regards
WJA
Quote Reply
Re: [warbuckle] about ms access forms In reply to
I do not quite understand. Do i copy and paste the sql into vba code, or what exactly do i do?