IF/THEN Syntax help needed....... Please assist

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

Guest

Hello to everyone,

My problem is probably an easy one for seasoned Access developers, but for
me, not so easy.

Need syntax for an easy IF/THEN statement for the following

2 forms linked by a common numeric Field. 1 is the main form and contains
a button to launch the 2nd. I need an ON OPEN IF statement for the 2nd
form that looks to the common field to see if it contains <>0 or is blank on
the 1st form, IF it does contain either a 0 or is blank then I want to ADD a
NEW RECORD to the database. Because if it does contain anything else, the
records will appear with the data for that client that has already been
entered. Now if I select a client and luanch the 2nd form by clicking the
button, it brings up random data that does not pertain to the current client,
seems like it's just grabbing data or maybe the last record it produced.

Thanks to anyone willing to give me the assistance I need, here's how
invision the syntax, please feel free to amend as necessary in your answer

If
FrmClient.Projectno=0 or is Null
Then
AddNewRec...........

See I'm an idiot. Help Please
 
If [common numeric Field] <> 0 or isnull([common numeric Field]) then
DoCmd.GoToRecord , , acNewRec
Else
'whatever you want to happen
End If


| Hello to everyone,
|
| My problem is probably an easy one for seasoned Access developers, but for
| me, not so easy.
|
| Need syntax for an easy IF/THEN statement for the following
|
| 2 forms linked by a common numeric Field. 1 is the main form and contains
| a button to launch the 2nd. I need an ON OPEN IF statement for the 2nd
| form that looks to the common field to see if it contains <>0 or is blank on
| the 1st form, IF it does contain either a 0 or is blank then I want to ADD a
| NEW RECORD to the database. Because if it does contain anything else, the
| records will appear with the data for that client that has already been
| entered. Now if I select a client and luanch the 2nd form by clicking the
| button, it brings up random data that does not pertain to the current client,
| seems like it's just grabbing data or maybe the last record it produced.
|
| Thanks to anyone willing to give me the assistance I need, here's how
| invision the syntax, please feel free to amend as necessary in your answer
|
| If
| FrmClient.Projectno=0 or is Null
| Then
| AddNewRec...........
|
| See I'm an idiot. Help Please
|
|
|
 
Back
Top