noob help please

[cdzajp]

Greetings one and all.

As the subject line details, I am an access noob and apologise now if my questions are to simple for this forum.

I have been reading about update queries and wondering if I can get some help.

I have started to create a database to log a gap analysis for our audit department rather than having it in excel What I am looking to do is as follows:

Main form shows information from table (i have used bound boxes to display this) however I have also written a search query to enable users to search for specific criteria.



What I want is when the search function is used it updates the form currently in view rather than opening a new one... is this possible? Can anybody please advise the steps to follow to make this work please.

My thanks and appreciation in advance.

Best wishes

Anthony

[orange]

Can you show us the query behind the Search?

Is the Search query available on the Main form? A button or something?


What exactly does this mean? Can you describe what you want with some sample data?

when the search function is used it updates the form currently in view rather than opening a new one.

There is a free video tutorial here that may be what you are looking for.
http://www.datapigtechnologies.com/f...dsetclone.html

[cdzajp]

Hi and thanks for the reply.

You are correct in your assumption that the query is run off a button on the main form, also duplicated within the data entry form, so for example if you were entering data into control number 9.2.1 but then wanted to jump to control 15.1.2, i wanted the search button to be able to show the record that is returned after the search on the same form rather than displaying as table or new form.

I think i'm looking for an update function to append to the query, that when the user enters the required control number, it displays the data on the form that the button is attached to.

The query is defined as follows with the controlling table called Gap Analysis:

Field: ID Gap Number Section Number Control Objective

Criteria: [Enter Section number]

[orange]

Take a look at the video I mentioned. I think it has the feature you want.