Linked Form Filteration

  • Thread starter Thread starter Faraz A. Qureshi
  • Start date Start date
F

Faraz A. Qureshi

I have a parent form "Clients" a child form linked via a toggle button
"Records". However, I have found that while creating a new record of clients,
unless I don't pass by ALL the fields the relevant entry is not found to be
made in the Records form.

In other words, I want the child form to be reflecting in it's related filed
of Customer the same name as in the opened Parent form's Client field, even
if the current parent record is not complete.
 
Seems like I'll have to use the Update method for the current record to be
first saved. Any tip?
 
Faraz A. Qureshi said:
I have a parent form "Clients" a child form linked via a toggle button
"Records". However, I have found that while creating a new record of
clients,
unless I don't pass by ALL the fields the relevant entry is not found to
be
made in the Records form.

In other words, I want the child form to be reflecting in it's related
filed
of Customer the same name as in the opened Parent form's Client field,
even
if the current parent record is not complete.
Click to expand...


I'm not certain I understand you, but I think the code (or macro) for your
button must save the current record before opening the Records form. In VBA
code, you might have these statements:

If Me.Dirty Then Me.Dirty = False
DoCmd.OpenForm "Records" 'maybe other arguments as well
 
Back
Top