Opening a form from a form using a command button

[Janice]

I have a blank form used as a "menu" on which numerous command buttons have been placed. These command buttons open up other forms or reports and even perform some updating and appending to the database once selected forms have been closed. There has been no problems with any of these buttons until I tried to create a new one

1). Query from one table with the following fields
ordered (yes/no check box format
name (text
member number (text)
member date (date
request date (date
name of requestor (text
date order placed (date).
2). Criteria for "Date order placed" is "is null
3). A form powered by this query was created in tabular format through the wizard. This form works like a champ until......
4). Attempting to create a command button on the menu page that will open this form generates this message
"You have chosen forms that can’t be linked. You must have at least one field that can be linked on each form.
5). Removing "is null" from the query criteria to the "date order placed" field doesn't make any difference

I am not understanding because it is one query, from one table, and one form. The others are actually more complex and have not rendered any problem. Help, help, hel

Thanks
Janic

 

[SteveS]

Janice

It sounds like the form opens with records if you open it by double clicking on it. What is the button OnClick event code you are trying to use to open the form? Would you post it

Stev