Opening a form with a Query

[Eeebs]

Hi,

Basically what I need my Query to do is ask me for an ID, which the user inputs and then open a form with the correct record already displaying. So far I can get it to ask for the ID but it shows the relevant record as a table/query rather than in a form. How do I go about doing this?

 

[John Big Booty]

Create a form and set the query as the Record Source for the form. Now just open the form, the query will ask you to input the ID then the form will open displaying the required record.

 

[Eeebs]

Thanks for the answer However in this mode, I cant edit/save/add/delete records. Is there a way so that when the answer is displayed, I can edit it. Im aware the results of a query cannot be changed but is there a workaround?

 

[John Big Booty]

In the words of Manuel ¿Qué?

If you are able to edit/save/add/delete records the way you are currently doing things, what I have suggested should not change things. All you are doing is making your current query the Record Source for a form.

 

[Eeebs]

In the words of Manuel ¿Qué?

If you are able to edit/save/add/delete records the way you are currently doing things, what I have suggested should not change things. All you are doing is making your current query the Record Source for a form.

Indeed, Thanks for your help

 

[rsteenoven]

I don't really understand, I have a query that when it searches for the ID, it opens in a datasheet view, how can I change it so It searches all my records and displays the record in the form view?

 

[rsteenoven]

Nevermind, sorted it