If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Opening a form from a form using a command button
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, help Thanks, Janice |
#2
|
|||
|
|||
Opening a form from a form using a command button
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? Steve -------------------------------- "Veni, Vidi, Velcro" (I came; I saw; I stuck around.) |
Thread Tools | |
Display Modes | |
|
|