Distinct Record Loaded Into Form

[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

 

[TKD Karen]

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