Query w form

[texasalynn]

I have a query that is using a form to get the user to fill in the blank. But how can I get the query/form to use like a lookup or a drop down box? I've tried making my form a combo box - but the query doesn't seem to incorporate that????? All help is greatly appreciated.

Thanks . . .
texasalynn

 

[WayneRyan]

texasalynn,

In the criteria row, for the appropriate column, put:

=Forms![YourForm]![YourControl]

examples:

=Forms![frmMain]![cboMyCombo]

The form must be open.

hth,
Wayne

 

[texasalynn]

Wayne - I have tried what you suggest, but it doesn't work. When I put in the query the criteria for my form, I go to my form to open and it is blank. What am I doing wrong?

thanks . . . texasalynn

 

[WayneRyan]

TexasLynne,

Can you compact, ZIP and post your db.

Wayne

 

[texasalynn]

I'm now having problems with the form "Entity".

Thanks for the help.

texasalynn

 

[texasalynn]

OK - I try again to attach.

 

[texasalynn]

Trying to attach one more time

 

[WayneRyan]

texasalynn,

Can you attach your db?

You might have to Tools --> DB Utilities --> Compact
to make it smaller, then ZIP it.

Wayne

 

[texasalynn]

Solved - Query w/form

Well I solved my issue. I never could get it attached and it's not that big. Thanks for the help