Subform question

  • Thread starter Thread starter Garth
  • Start date Start date
G

Garth

I have a database that contains a form and a subform
within it. I enter data on the main form which populates
the subform if sepcific criteria is met. I'd like to be
able to double click on a line of data in the subform and
have it autofill the main form for editing. I'd also like
access to assign a new id to this record so I can maintain
versions of my records.
 
The subform should never be used to fill in the main form data. In a
relationship type database, the main form is always the one-side and the sub
form is the many side of the relationship. In other words, there must be a
record in the one-side before the many-side can be created.

If you do not have referential integrity set on your database, you may want
to read up on these topics first:
Normalization
Referential Integrity
Entity Integrity
Primary Key values
Foreign Key values.
 
I don't think I explained this very well. The main form
populates table "a". I then created a subform in the main
form, based a query that extracts data from the table "a"
based on certain criteria. What I'd like to be able to do
is doubleclick on a line of data in the subform (which is
data already populated from the main menu) and have the
data appear in the main form window. I would then like to
be able to edit the data and update the table "a" so the
new data appears in the subform.

I am currently doing it now by entering the id number of
the record in the subform, in the id field on the main
form and applying a goto record command using a command
button. The double click option above would be much
quicker and less manual input.

Maybe you can also tell me how to make a record in the
subform blink if certain criteria is met?? I can change
the colour of the record but would like to go further with
this conditional formatting.

Thanks.....Garth
 
Back
Top