By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,656 Members | 1,893 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,656 IT Pros & Developers. It's quick & easy.

Quick Question - Row Source, Unique values required

P: 50
Hi guys, probably an easy one for you.

I know how to limit a row source sor a combo on a form (setting unique values). The problem i'm having is that the query is the record source for a continuous subform within my main form. I am then limiting the form by making the criteria in the query the textboxes / comboboxes in the main form header.

I need to limit the continuous subform by machine (for a scheduling db) but I want the rows within the combo for 'machine' taken from the query that is the record source for the subform itself.

I have done the following:


Query criteria for 'Machine':
[Forms]![Frm_Schedule]![ComboMachine]

I then set the combo up and set it up with:
Name: ComboMachine
Row Source Type: Table/Query
Row Source: Query_Schedule
Bound Column: 3

...the list is working as it brings up the possible machines that are in the query but it lists them in the order they are in the query with repeat values, is there any way of making these unique to pick from?
Jan 24 '08 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 446
Hi

I think that you need to check Query_Schedule says something like

"SELECT DISTINCTROW Field1, Field2 etc"

S7
Jan 28 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.