I’ve got 2 questions about Access.
First one. I’m using a form and subform. For some records of the form, the subform is empty. I want to make sure that the form doesn’t show these records of the form. So when the subform of the record is empty, don’t show te subform and record at all.
Second one. I’m making use of a datasheetform and a standardform based on the same query. The datasheetform serves as an overview and the standardform is there for editing the record and see more details. In the query is a field called [ID]. When I doubleclick on the ID of a record in the datasheetform I want Access to open the standardform on that same record with the same ID. Is there someone who can help me with the code I need to write fort his?
Hope you understand what I mean!