Multiple updtates

  • Thread starter Thread starter Eric Plante
  • Start date Start date
E

Eric Plante

I'm using Access 97 and I have a form that contains 2 sub-forms and the
tables associated with the sub-forms contains the same key as the table
associated with the main form.

The key associated with the main form will get filled by the user but not
the key associated with the sub-tables; I'd like them to get filled
automaticaly when saving the data.

If I was doing pure SQL, I'd create new rows and it would be easily done but
how can it be done with Access? I didn't start using VB and don't know how
to program with it yet so I'd prefer a solution without VB at the moment if
possible of course.

Thanks
 
Nevermind, I found out a more intelligent way to do it, I just realised that
I can make different forms out of the same table.
 
Eric said:
Nevermind, I found out a more intelligent way to do it, I just realised that
I can make different forms out of the same table.
Click to expand...

It sounds like you should be using the subform control's
Link Master/Child properties.
 
Eric said:
I have FormA that contains KeyA and FormB that contains KeyB which is the
same as KeyA and FormB is a subform of FormA. I want Key B to be filled when
KeyA is filled since KeyB will not show in FormA

Now, I create FormA then I create a subForm control into it and I fill the
property section with the subform. What do I put into the Master and Child
section? I tried writting the name of the columns that will contains KeyA
as master and KeyB as child but KeyB isn't filled when KeyA is.
Click to expand...

It's not supposed to *display* KeyB as soon as you type a
value for KeyA. It will make sure that the subform only
displays records where KeyB = KeyA. It will also fill in
the value of KeyB automatically when you create a new record
in the subform.

Why do you want to see the value of KeyB when it is the same
as KeyA? It is normal in this kind of situation to make the
subform's text box for KeyB invisible.
 
Back
Top