Criteria for combo box depends 'edit records or add new'

[Joy]

Hi,
Is it possible to have the source of a combo box show all records if user is
editing data and show specific records if adding new data?

I've come up with one way (like a lookup field in front of the combo box)
but that's really slow. There's got to be an easier solution.
Joy

 

[Allen Browne]

In the Enter event of the combo, you could set its RowSource to an SQL
string, depending on the value of Me.NewRecord.

 

[Joy]

Thank you Allen. I'll try that.
J

In the Enter event of the combo, you could set its RowSource to an SQL
string, depending on the value of Me.NewRecord.