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

Combobox in sub-sub-form

P: n/a
TS
I have a combobox bound to a field in a sub-sub-form which remains blank as
I traverse through the records in the parent form.

It works fine when I have a simple rowsource query but remains blank when I
add more critera for the search. I also have to requery it everytime I
change the parent record. Is there an easy/better way to display field
values in a combobox whilst specifying additional criteria in the row
source?

Rowsource = SELECT cont_nbr, cont_firstname, cont_lastname FROM cont_mstr
LEFT JOIN ad_mstr ON cont_ad=ad_nbr WHERE
(((cont_ad)=forms!frmApptReport!appt_ad)) Or (((ad_name) Like "customer"));

TIA
Ken
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.