Code to check the contents of a field in a table where another field = something (1 Viewer)

brainox · Sep 11, 2013

HI
I am trying create some code that checks if the contents of the status field in a table is "Authorised" where the ID = something specific for multiple records. If all records witht the specific ID are "Authorised" Then generate a new record in another table.
I know it's poorly explained but it's the best I could do I'm afraid.
I have no idea where to start, perhaps a Dlookup?
Any ideas would be greatly appreciated
Many thanks in advance

pr2-eugin · Sep 11, 2013

DLookUp is a good place to start..

Code:

If Nz(DLookUp(......), "NA") <> "NA" Then
[COLOR=Green]    'your CODE to add New record.[/COLOR]
End If

Code to check the contents of a field in a table where another field = something (1 Viewer)

brainox

Registered User.

pr2-eugin

Super Moderator

Similar threads

Users who are viewing this thread