Populate Combo box based on Parameter Query

[resslers]

I have a combo box on my form that I would like to populate based on a field value contained in a textbox on the same form. This textbox is populated when the form is opened.

I have tried to create a parameter based select query for the rowsource, but to no avail. Currently, this is the statement that I'm using.

SELECT [Insurer].[I_Name], [BetaColon].[PTID]
FROM BetaColon INNER JOIN (Insurer INNER JOIN INSURER_DTL ON [Insurer].[ID]=[INSURER_DTL].[Insurer]) ON [BetaColon].[PTID]=[INSURER_DTL].[Id]
WHERE ((([BetaColon].[PTID])= ??needs to be the field value??

If I hard code in a value the combo box works (I'm requerying using a macro each time I enter the combo box).

What is the correct syntax for getting the parameter value into my select statement?

Any help is greatly appreciated.

resslers

 

[jgoodman00]

Your WHERE statemenet should be in the form of:
WHERE ((([BetaColon].[PTID])= [Forms]![frmName]![ControlName]))

This assumes it is not working as a subform...


James Goodman

 

[HenryAnthony]

Hi resslers,

Just put the reference to the form field in the critera of your query. Then you can go to view SQL to see the statement. HTH

Best regards,

Henr¥