OPen Form B from Form A with related records

[Peter]

Hi again

I receive syntax error on the following

DoCmd.OpenForm("Single
View",[ViewAsAcFormView=acNormal],,[WhereCondition:"Case ID ="&Me.Case ID])
all i want to do is to open Form B from Form A with related records by
klicking on a command button...

 

[golfinray]

The command button will set that up for you using the openargs portion of the
docmd function.

 

[Allen Browne]

This should work provided Form B is not already open:

Dim strWhere As String
If Me.Dirty Then Me.Dirty = False 'Save first
If IsNull(Me.[Case ID]) Then
MsgBox "Select a case first."
Else
strWhere = "[Case ID] = " & Me.[Case ID]
DoCmd.OpenForm "Form B", WhereCondition:=strWhere
End If

 

[Peter]

Thank you! Thank yuo! Thank you! Beer is on me when you visit Prague.

The command button will set that up for you using the openargs portion of the
docmd function.

Hi again

I receive syntax error on the following

DoCmd.OpenForm("Single
View",[ViewAsAcFormView=acNormal],,[WhereCondition:"Case ID ="&Me.Case ID])
all i want to do is to open Form B from Form A with related records by
klicking on a command button...

 

[Dirk Goldgar]

Hi again

I receive syntax error on the following

DoCmd.OpenForm("Single
View",[ViewAsAcFormView=acNormal],,[WhereCondition:"Case ID ="&Me.Case
ID])
all i want to do is to open Form B from Form A with related records by
klicking on a command button...

Did you not see my reply when you asked this same question two days ago in
the GettingStarted group?

 

[Peter]

Dirk...i appologize, i did not. I am new to this kind of forum and it takes
time to undderstand the routines...once again...i am sorry.

Hi again

I receive syntax error on the following

DoCmd.OpenForm("Single
View",[ViewAsAcFormView=acNormal],,[WhereCondition:"Case ID ="&Me.Case
ID])
all i want to do is to open Form B from Form A with related records by
klicking on a command button...

Did you not see my reply when you asked this same question two days ago in
the GettingStarted group?

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[Dirk Goldgar]

Dirk...i appologize, i did not. I am new to this kind of forum and it
takes
time to undderstand the routines...once again...i am sorry.

No problem; it just seemed strange that your question didn't change, and I
thought I'd answered it.