How do i set field values from one form to another form

  • Thread starter Thread starter Guest
  • Start date Start date
A very similar question was just asked and answered.

A form has a data source. The field value is saved in the table. If you
have two (or more forms) that pull from the same table, then they will all
show the same value.

If that does not answer your question, please take the time to include full
sentences and explain exactly what you are trying to accomplish. Include
what types of forms/fields/controls you are talking about.
 
sorry for not making myself clear...

i am trying to calculate a field using database fields on a form.

FEIState, FEIMonth, FEIDay, FEIYear are all combo boxes that are used to
create a field called Project.

i calc that field on one form in the field FEIProject = FEIState & FEIMonth
& FEIDay & FEIYear.

It's calc'd on a form called EstimatorInput.

i want this calc'd field to show on two other forms.

when i go to the other forms and place FEIProject on the form, i get #Name
in the field.

do i need to create temp or variables to hold calcd information or what?
again, sorry for being so vague previously.
 
No, just add the same unbound field in your other form. In that unbound
field, simply put...

= FEIState & FEIMonth & FEIDay & FEIYear.
 
Back
Top