Problem adding a command button to a form in order to open another form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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:
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
 
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

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
 
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.
 
Back
Top