Continuous Form Combo Box with rowsource based on hidden field.

R

Rickety107

I have a combo box on a continuous form. Based on the value of a hidden text
box, I need the combo box to display different values since there are
different values available for selection based on the city of the record. I
have the following query as my rowsource

SELECT qrySelectOpenAPPeriods.[Period] & " " & [Year] AS Period,
qrySelectOpenAPPeriods.PeriodID FROM qrySelectOpenAPPeriods WHERE
(((qrySelectOpenAPPeriods.fldCityCode)=[Forms]![LookupDepositRequestsForSolomon]![fldCity]))
ORDER BY qrySelectOpenAPPeriods.Year, qrySelectOpenAPPeriods.Sequence;


The combo box is populating. The problem is that when they click on the
close button which contains DoCmd.close acForm, Me.Form.name a parameter box
appears asking for the value of
[Forms]![LookupDepositRequestsForSolomon]![fldCity])) . How do I stop this
from occuring
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clearing combo boxes and a text box 2
Link a text box based on drop down box with four options MS Word 365 0
Dynamic Naming of Form Button 3
Combo box 0
DLookup in Continuous form 0
Prevent duplicate selection from combo box on continuous form 4
Using combo box when adding records to continuous form 1
Combo Box with RowSource based on Textbox Value won't "refresh" 1

Top