Paul has attended:
Excel Advanced course
Access Intermediate course
Access Advanced course
Enabling a query-based form to enter new data
I've created a form using a query that crossses three tables. It displays existing data fine, but I am unable to enter data in the 'new record' form. As far as I can see the fields are enabled for text input on the field properties. How do I enable the form to add new records? And is there a way of adding controls to the form to select data from the three tables whch does not elimnate pre-populated data in the form?
RE: Enabling a query-based form to enter new data
Hi Paul,
Thank you for your question.
Have you created a sub form? Have you looked at the form properties to try and enable data input?
In response to your first question, try creating a macro that opens the form in Add Mode and see if that sorts the problem out.
The second question may need a little more thought.
Regards
Simon
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
