Linked Form Filteration

[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.

 

[Faraz A. Qureshi]

Seems like I'll have to use the Update method for the current record to be
first saved. Any tip?

 

[Dirk Goldgar]

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.

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

 

[Faraz A. Qureshi]

Me.Recalc did it!

 

[Dirk Goldgar]

Me.Recalc did it!

Then I must not have understood you correctly. I'm glad you got it working.