populate field

  • Thread starter Thread starter debpep
  • Start date Start date
D

debpep

I have two continuous forms based on two separate queries
where for one form the criteria of Field = x and one
where the query of Field = z from one table. I would
like to automatically populate Field of form x with "x".
And the same for form y. Would appreciate help.
Thank you.
 
hi,
confused. what do you mean automaticly populate the forms?
the query already does that.
do you mean update the form when the tables are modified?
if so. in the forms timer event you could put
me.requery and set the timer for every 30 seconds????
let me know.
 
O.k. To be more exact: this field that is to be
populated is currently populated with one of two choices:
x or y (actually blood cell type, but that is
irrelevant). One continuous form records the x
transfusions and one is for recording the y transfusions.
But, the celltype field is populated by a choice made by
a combo box. I would like to populate the celltype field
in the form for recording x transfusions automatically (x
entered into the field by virtue of being in this data
set) and likewise the y celltypes. The reason for the
two separate forms is to track each type of transfusion
separately and keep a running count on the header of the
number of records and number of x and y units
separately. Hope this makes better sense.
 
Back
Top