Distinct Record Loaded Into Form

  • Thread starter Thread starter Doug L
  • Start date Start date
D

Doug L

I'm trying to load a distinct record into a form and I
have been trying to do it with a Command Button. Is this
possible without a lot of VBA code? Or is there another
simpler method? I'm developing a database to track
customer and vendor quotes which will get very big in a
short period of time so loading distinct records into the
form is the only way to go.

Thanks,
Doug
 
You would set this in the recordsource query. The query properties (not the
field properties) window asks if you want distinct values - set it to yes.

Karen
 
Back
Top