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
|
|||
|
|||
Problem adding a command button to a form in order to open another form
I have another form that acts as a "menu" (named "frmMENU") on which numerous command buttons have been added so that other forms and reports can be opened from that one location. They all work great, even the ones with multiple step macros attached.
PROBLEM:P I have a form (frmYN) that has a column of Y/N boxes next to names. This form is powered by a straight forward query which derives its fields from one table. The query runs fine and when the form opens up there is no problem. When I try to add a command button to frmMENU that will open up frmYN, a message box pops up that says: "You have chose forms that can't be linked. You must have at least one field that can be linked on each form". This has never happened before. Can someone help? Thank you, Janice |
#2
|
|||
|
|||
Problem adding a command button to a form in order to open another form
It sound to me like you are trying to add a subform, which needs to link to
the main form some how. If you add a button to open a form, you should not encounter an error like you mention. If you do, when does this error appear? When you click the button? While you are in design view? More details please. Rick B "Janice" wrote in message ... I have another form that acts as a "menu" (named "frmMENU") on which numerous command buttons have been added so that other forms and reports can be opened from that one location. They all work great, even the ones with multiple step macros attached. PROBLEM:P I have a form (frmYN) that has a column of Y/N boxes next to names. This form is powered by a straight forward query which derives its fields from one table. The query runs fine and when the form opens up there is no problem. When I try to add a command button to frmMENU that will open up frmYN, a message box pops up that says: "You have chose forms that can't be linked. You must have at least one field that can be linked on each form". This has never happened before. Can someone help? Thank you, Janice |
#3
|
|||
|
|||
Problem adding a command button to a form in order to open another form
The first form (frmMENU) is a "dummy" form. In form view, frmMENU has numerous command buttons that, when clicked, open up various reports and input forms.
The second form (frmYN) is a form that with a query as its source. The query has several fields (one of which is a Y/N check box field) from one table.....very basic. When the query is fired up it runs like a champ. Same with the form. Here's where the problem comes in: 1. In design view of frmMENU, the command button icon on the tool bar is clicked and the wizard activated. 2. Catagory option "Form operations" is chosen, and Actions option "Open Form" is chosen. 3. Click "Next" and choose frmYN from the list of choices. 4. Click "Next" and then click "Open form and find specific data to display". Wow...just solved the problem! I've been clicking "Open form and find specific data to display" instead of "Open the form and show all records". Have no idea what possessed me to make that choice. The command button on frmMENU for frmYN works just fine now. Sorry to take up your time. |
Thread Tools | |
Display Modes | |
|
|