A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Opening a form from a form using a command button



 
 
Thread Tools Display Modes
  #1  
Old May 7th, 2004, 10:21 PM
Janice
external usenet poster
 
Posts: n/a
Default 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  
Old May 7th, 2004, 11:26 PM
SteveS
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:33 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.