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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Two Tables Using One Form Contents 0
Main Form and two Subforms 2
Copy record info into new form 0
Continuous Form: Change the color of one row 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Need help on how to pass calculated field from a form to another form 0
Forms retain a value 1
Open a form from a continuous form based on two field values 2

Back
Top