Access combobox asks for parameters when rowsource query returns no records
I have a comboxbox which gives a list of recent delivery addresses used by the client which works fine if there are any records, but asks for a parameter if the select distinct rowsource query returns no records because the client hasn’t used a delivery address before.
MS-Access Form – Using Two Combo Boxes to display records on the form
I have an MS-Access form that will be used for data entry, as well as to view data if the user chooses to do so.
I have two combo boxes at the very top of the form.
ComboBox1 provides a list of “EntryTypes” that the user can choose. Once the EntryType is chosen, ComboBox2 should only display a list of IDs for previous records of that specific type. Then the user should be able to select a specific entry ID and view the record within the form.