A
Alan
Salutations to the Group!
The further I go with Access, the more you guys have taught me that there
are simpler ways to do things. In the pursuit of simpler... My dilemma is
that I have a command button routine that opens another form while passing
the key value (PersonID) as the filter argument. Things are simple and
great... until now.... that I realize that my future users for this
distributed app won't have preexisting data, or accessibility to the data
tables.
I guess that NOT everyone is able to "just add an initial data line to the
table". My desire is to get a "tip from the top" for alternative methods of
dealing with form navigation when forms are user-specific and empty of data.
I can only see two options:
1) Test for the presence of Form #2 from Form #1. Branch to the new form
by either passing lookup criteria if data is there, or by opening a blank
form with OpenArgs passing the PersonID key value to the new record.
2) Simply pass the PersonID key value as an OpenArg value with
"Docmd.FormOpen" to the new form, then do the conditional lookup or new
record decision-making on the Current Event of the new form, having the
current event populate the PersonID value.
Am I missing an easier approach? Thanks!
Alan
The further I go with Access, the more you guys have taught me that there
are simpler ways to do things. In the pursuit of simpler... My dilemma is
that I have a command button routine that opens another form while passing
the key value (PersonID) as the filter argument. Things are simple and
great... until now.... that I realize that my future users for this
distributed app won't have preexisting data, or accessibility to the data
tables.
I guess that NOT everyone is able to "just add an initial data line to the
table". My desire is to get a "tip from the top" for alternative methods of
dealing with form navigation when forms are user-specific and empty of data.
I can only see two options:
1) Test for the presence of Form #2 from Form #1. Branch to the new form
by either passing lookup criteria if data is there, or by opening a blank
form with OpenArgs passing the PersonID key value to the new record.
2) Simply pass the PersonID key value as an OpenArg value with
"Docmd.FormOpen" to the new form, then do the conditional lookup or new
record decision-making on the Current Event of the new form, having the
current event populate the PersonID value.
Am I missing an easier approach? Thanks!
Alan