Hi everybody, new to Bytes, thanks for looking at my problem. I have a main form (Main) with 3 subforms in it (Customer), (Address), (Account). All these are based on queries which prompts the user for the customer ID. How can I get it to only prompt for this information once when opening the main form? Ideally it would be entered once to populate the main form and the subforms would populate based on the Customer ID field on the main form.
-
-
When setting up a SubForm control there are properties you can view. Some of which control which records are allowed in the SubForm related to the current record in the main form. I suggest you go and have a play with those. Come back if you can't manage to find your way around, though it's pretty straightforward so I doubt we'll see you back on that score.
As far as entering IDs goes, you may want to explore the concept of filtering based on existing lists found in a ComboBox instead. There is a tutorial on this found at Example Filtering on a Form.
Comment