use of OR in expression

[KenHigg]

Ok. Then from scratch.

Forms 1 and 3 open form 2

On form 1,
1. What is the form name?
2. What is the name of fld you use the primary key?
3. What is the name of the surname fld?

On form 3,
1. What is the form name?
2. What is the name of fld you use the primary key?
3. What is the name of the surname fld?

On form 3,
1. What is the form name?
2. What is the name of fld you use the primary key?
3. What is the name of the text box where you want to display the in?

 

[fuglyjowls]

Ok. Then from scratch.

Forms 1 and 3 open form 2

On form 1,
1. What is the form name? frmcontacts
2. What is the name of fld you use the primary key? id3. What is the name of the surname fld? surname

On form 3,
1. What is the form name? order summary
2. What is the name of fld you use the primary key? order no
3. What is the name of the surname fld? surname

On form 2,
1. What is the form name? frm orders2. What is the name of fld you use the primary key? order no
3. What is the name of the text box where you want to display the in? surname header
__________________

 

[fuglyjowls]

Ok. Then from scratch.
answers below in blue
Forms 1 and 3 open form 2

On form 1,
1. What is the form name? frmcontacts
2. What is the name of fld you use the primary key? id
3. What is the name of the surname fld? surname

On form 3,
1. What is the form name? order summary
2. What is the name of fld you use the primary key? order no
3. What is the name of the surname fld? surname

On form 2,
1. What is the form name? frm orders2. What is the name of fld you use the primary key? order no
3. What is the name of the text box where you want to display the in? surname header
__________________

 

[KenHigg]

Then I think the code would look like this:


DoCmd.OpenForm "frm orders", , ,"[order no] =" & me![order no]