Objects wont let me enter data

A

APH

Hi
I have created a query which involves 4 different tables. I have then
created a form based on the query. The form is essential a contact form,
but with a check box and date field. For some reason when i try to click in
the tick box, or enter a date into the date field, nothing happens and i
cannot update the record.

can someone tell me what basic mistake i have made

Thanks

Alex
 
W

Wayne Morgan

The first thing to check is to open the query and see if you can edit the
fields there. If not, then the query isn't updateable and you won't be able
to edit them in the form either.
 
A

APH

Thanks Wayne, in fact the Query recordset was not updatable. I have done it
another eay using a sub form which is working. Thanks for your help

Alex
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top