chingchanglang
Last Activity: Apr 27 '07, 07:18 PM
Joined: Jun 5 '06
Location:
-
Thanks Wendy, but I got it. Turns out I didn't need to pass both variables, just one. So the first post worked. -
What is wrong with this line of code? Now I'm getting a syntax error? I'm trying to pass in 2 arguments when I open the form. Anyone?
If Not SysCmd(acSysCmd GetObjectState, acForm, "Edit Topic Information") Then
DoCmd.OpenForm "Edit Topic Information", acNormal, , ("[Topic_Number] = " & Me.Topic_Number .Value & " AND [Topic_Descripti on] = " & Me.Topic_Descri ption.Value)...Leave a comment:
-
Got it...this seems to work for anybody that needs it:
If Not SysCmd(acSysCmd GetObjectState, acForm, "Form Name") Then
DoCmd.OpenForm ("Form Name")
End IfLeave a comment:
-
Err - Not a Valid Bookmark
Hi...Below is my code where I am trying to get the recordsetclone of one page and take it to an Edit page where I can edit it. There are onlyl two pages, one primary key, Topic Number. Anyone have any ideas where I'm going wrong? I've checked the properties on the Edit form. I've tried bining them and unbounding them to no avail! :confused:
Private Sub btn_EditTopic_C lick()
On Error GoTo Err_btn_EditTop ic_Click... -
How do I open a form without showing it?
HElp! I need to open a form without actually opening it. I'm thinking more of "Loading" it so I can use its recordset. But I do NOT want to see it. i have no clue....
Thanks! -
Opening a Form based on a cmboBox
Hi, what I'm trying to do is probably very simple...but simple is relative! :D
I have a cmbo box on a form "[View All Topics]". It is populated with a query to show me all the Topics in my table where the primary key is "Topic_Numb er". I want to choose one, select "Search" btn, and then have the "Topic_Informat ion" page display with it's results based on the Topic_Number. This is what I have in the...
No activity results to display
Leave a comment: