Update Form

  • Thread starter Thread starter casih
  • Start date Start date
C

casih

I have a main form called Members Overview and a sub form called Case
Details. I wish to have a command button on Overview which will open a new
Case Details form and populate certain fields at the same time (Membership
Number, Surname and Firstname).

All I can manage to do is get a blank form ready for populating but ideally
i would like all the info above already populated.

Hope this makes sense!
 
You should have two tables - Members & Case.
The Members needs a primary key (Membership Number - Autonumber works well)
and a foreign key in Case that will match it. Set a one-to-many
relationship with Referential Integerity and Cascade Update between the two
tables.
In the form set the Master/Child links using the primary key/foreign key.
There is no need to include Surname and Firstname in the Case table, just
foreign key related to Membership Number primary key.
When the main form is on the member record any new record added to the
subform will automatically have foreign key that relates to Membership Number.
 
Hi,

I have done all that but what I am wanting is to be able to click on a
command button (or something to that effect) and it open a new case details
form with just the members info in. A member may have more than one case
against them so I want it just to show a blank form with members details. is
this possible?
 
The main form will have just the members info showing. The subform will have
case details.
You can have a button on main form to create a new case details record.
Use macro action GoToRecord with argument - New.
 
Back
Top