Subform not working (1 Viewer)

K

Kermit1976

New member

Local time

Today, 06:24

Joined

Mar 26, 2018

Messages

3

• Mar 27, 2018

• #1

I have a form which works fine on its own, but doesn't perform the same when used as a subform.

I have 2 combo boxes where 1 selection limits the selection in the next combo.

I have a macro which is FORMS!projectdetails!cboequipmentname

When I select the 1st combo drop down it asks me to fill in a value.

Any help would be appreciated.

Thanks

 

Ranman256

Well-known member

Local time

Today, 09:24

Joined

Apr 9, 2015

Messages

4,339

• Mar 27, 2018

• #2

we dont know much:
is the combo bound to a field?
is the subform connected to the master form?
does the combo have a working query as source?
etc...

 

K

Kermit1976

New member

Local time

Today, 06:24

Joined

Mar 26, 2018

Messages

3

• Mar 27, 2018

• #3

Combo is bound to a field
Subform is connected to Masterform
Combo has a working query

Everything works if I open the form on its own.

Thanks for the help.

 

P

Pat Hartman

Super Moderator

Staff member

Local time

Today, 09:24

Joined

Feb 19, 2002

Messages

43,196

• Mar 28, 2018

• #4

When a form is placed on another form, references change because the main form becomes the top level. So, if the reference is currently

Forms!myform!mycontrol

It has to change to:

Forms!mainform!myform!mycontrol

 

K

Kermit1976

New member

Local time

Today, 06:24

Joined

Mar 26, 2018

Messages

3

• Mar 28, 2018

• #5

Thanks Pat. Form working exactly as I want.