How Can Update a Form with a query as Record Source 1

[Loui2005]

I trying to enter data in a form having a query as a Record Source.
Can anyone help me please?

 

[PHV]

Why not simply follow the form wizard ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[AppStaff]

Its very simple to use a query as a datasource. Just construct your query first and then select it from the datasource dropdown.

I'm guessing your problem is that your query is not updateable.

To make sure your query is updateable look at the last row. if you can type a new record at the end then it is.. if you cannot then it is not.

If you've used some related tables in your query then this may be the source of the problem. if your doing so to provide lookup values on your form then consider using Dlookup in the source query to produce those instead of relating to the table.

This should point you in the right direction. Good luck.

 

[Loui2005]

Hi Guys!!

Thanks a lot for your help. AppStaff, you are right. I've used a related table in the form. What I need to do is use this Form as data entry to capture data. I think I would for a make table query, and then put that table in the Form's Record Source. What do you think about this guys.

Hey Millions of thanks!!!!

Lou

 

[PHV]

I've used a related table in the form
To make the query updatable use an INNER join and select the PrimaryKeys.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[AppStaff]

Loui2005,

Might be better if you present your query sql and perhaps some of your table structure thats in the query.