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

  • Thread starter Thread starter Joy
  • Start date Start date
J

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
 
In the Enter event of the combo, you could set its RowSource to an SQL
string, depending on the value of Me.NewRecord.
 
Thank you Allen. I'll try that.
J
Allen Browne said:
In the Enter event of the combo, you could set its RowSource to an SQL
string, depending on the value of Me.NewRecord.
Click to expand...
 
Back
Top