Forum Discussion
Solved
Combobox goes empty on new record
Hi all - silly issue that somehow I can't get the answer to. Any help is appreciated. I have an Access database (dataverse backend). I'm using a data entry form, which works well. There are a varie...
- It's not the only way to handle the situation. However, it is the appropriate way for a relational database application.
Show us the SQL from the row source for the combo box.
Show us the SQL from the record source for the form.
Is the form in Datasheet view, Continuous view or Single Form view?
thanks for your reply.
The form recordsource is: SELECT * From Policies
The rowsource for the combobox is:
SELECT Policies.Risk_Name
FROM Policies
GROUP BY Policies.Risk_Name
ORDER BY Policies.Risk_Name;
It's a Single Form.Ps the control is linked to Risk_Name too
- Do you not have a look up table for "Risk_Names"? That would be the normal approach. This approach sort of works, but has the unfortunate side effect observed.
- hmm do you mean creating a "lookup wizard" in the table design for that column? If so, not sure that works with a dataverse back end?
