Synchronised forms

[Ericmcnulty]

I am using one combo box to select to select from a list defined by another
combo box and using after update to requery the combo box. All works fine as
a single form but when the form is used as a subform the Parameter Value box
asks for a value which works fine but cant get it to work without the
parameter value coming up

 

[Dennis]

The RowSource properties will be different if the combo boxes are on a
subform instead of a form. If one is based on the other, you will be using
something like [Forms]![FormName]![ComboName]. This will obviously be invalid
if your form is then a subform of another form. It will need to be something
like this
[Forms]![Formname]![SubFormName]![Form]![ComboName]

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), there is a small Access
database sample which illustrates what Dennis was talking about. It's
called: "CascadingComboBoxes.mdb" One of the samples there uses a subform.

--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Ericmcnulty]

The row source is from a table?

The RowSource properties will be different if the combo boxes are on a
subform instead of a form. If one is based on the other, you will be using
something like [Forms]![FormName]![ComboName]. This will obviously be invalid
if your form is then a subform of another form. It will need to be something
like this
[Forms]![Formname]![SubFormName]![Form]![ComboName]

I am using one combo box to select to select from a list defined by another
combo box and using after update to requery the combo box. All works fine as
a single form but when the form is used as a subform the Parameter Value box
asks for a value which works fine but cant get it to work without the
parameter value coming up

 

[Ericmcnulty]

Thanks for the advice got it working this morning