Adding New Data

[gary.newport]

I have a subform that is based upon a query. The output of the query is filtered by whatever is given within an unbound textbox on the main form.

When I select the relevant fields on the main form then the subform shows the related fields from the query; which is exactly what I am looking for. So far so good!

However, I want the system to allow someone to change the values if they so need to. I also want to allow them to add new records as required.

When I open the query the ADD NEW record area is missing and I cannot change any values in the query.

Where am I going wrong?

 

[vbaInet]

Herein, you will find an answer to your question:

http://allenbrowne.com/ser-61.html

 

[gary.newport]

Thanks for that. It was the Group By that was causing the issues and I would never have found that one out.

 

[vbaInet]

You're welcome. One more thing you could add to your favourites

Good luck with the rest.