Query and forms

[Nixx1401]

I created this parameter query which prompts you for a visitor name and name of child, this query is used to create a form when the form opens it autofills the visitor information for the visitor corresponding to the respective child. the subform in the form has transaction information such as transaction date, type of mail such as visit, mail or postcard and the process sending or receiving.

I place a add a new record command button I want when the add new record is clicked the dialog box from the query prompts you each and every time for the childs name and visitor name so this information is autofilled all the time.

I have 3 tables: Child, Visitor and transactions

[llkhoutx]

and . . . the question is?

[Nixx1401]

I would like to change the parameter to a dialog box which will prompt the user for the Visitor name and child name.

Fields in the query:
Field StrChildNo
Table Child

Concatenation of Child Name

Concatenation of Visitor Name

Fields containing the visitors address

I have criteria under the Visitors Name and Child name and when the form opens this information is autofilled. I would like change the parameter pop up box to a dialog box which have combo boxes listing the concatenations of the child name and visitors name and fill the form with this information.

[llkhoutx]

An input box, the prompt in a query, does not allow a combo box. Use a popup form for a combo box.

[Nixx1401]

dont quite understand

[llkhoutx]

Your words

parameter pop up box 

implies to me an "InputBox" from "[Specify child Name]" in your query, e.g

SELECT * FROM YourTableOrQueryName WHERE Name = [Specify Child Name] 

When the query is run, you'll be prompted to "Specify Child Name" with a textbox to specify the child' name.

My words

combo box 

implies a control on a form used in a query criteria, e.g.
Forms!YourFormName!ComboBoxName = "Jones, John"
Your query would be

SELECT * FROM YourTableOrQueryName WHERE Name = Forms!YourFormName!ComboBoxName 

When the query is run the forms control's value is put into your query automatically.