two fields same data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi this is very basic, but I am stuck, how do I show two fields w/ same data
in the form? For example, I have a field NAMEFIELD that come from table
LOCATOR and I want the show in the form NAMEFIELD and I have another field
NEWNAME that shows me what name in at the first one. Thanks
 
Fields are in tables. Forms have controls such as text boxes and combo
boxes. These controls may or may not be bound to a record source in a table
(or query). Bind two controls to the same record source if you want them to
show the same data. In this case set the record source of each to NAMEFIELD.
This assumes that NAMEFIELD is a field in the form's record source.
 
May I suggest that if you are just trying to view the data you may do better
to use a report. You can group by a field, then in another field (such as
ExpenseAmount) you
can set the text box to running sum Over Group. Make the text box invisible
on the form, but place an unbound text box in the group footer that
references the unbound text box on the form's detail section. I won't go too
far in that direction unless you are interested.
I'm having a little trouble understanding the current situation. If the
text boxes containing = sum([Mediaexpenseid]) and =sum([Expenseamount]) are
showing the correct amounts, you may be able to solve the problem by applying
the calculation in another unbound text box in the footer:
=[txtMediaExpenseID] + [txtExpenseAmount]
If that number is correct, and if you need that total to appear elsewhere on
the form, you can just reference that text box.

Savanah said:
Bruce never mind, worked very well, thanks. Can you help me and another matter?
I have a form(from 1 tables)that shows
STUDYID
STUDYNAME
BUDGET
and a subform (from a table) that shows:
Mediaexpenseid
Studyname
Expenseamount.
I am triyng to habe a field that shows balance and totalexpenseamount,
I did what someone helped me with :
To get the total expense create a field and in the source of the field write

=[Mediaexpenseid]+[Expenseamount]
If the subform is a single form, that has only one data then you can create
a field on the form and the source of that field write
=[BUDGET]-nz(Forms![MainFormName]![SubFormName].Form![Mediaexpenseid] ) -
nz(Forms![MainFormName]![SubFormName].Form![Expenseamount] )

If the sub form is continues form, that has few records, then create in the
footer of the sub form two fields, to sum the expense, make the fields not
visible.
write in the source of each on of them
= sum([Mediaexpenseid])
=sum([Expenseamount])

create a field in the form like mentioned above but write in the source of
the field

=[BUDGET]-nz(Forms![MainFormName]![SubFormName].Form![SumOfMediaexpenseid] )
- nz(Forms![MainFormName]![SubFormName].Form![SumfExpenseamount] )

The problem is the balance is showing is wrong: it adding my expenseid's
number to my sumofexpenseamount and is not right. Can you help me?? Thanks




Savanah said:
Thanks Bruce, I did before a lookup query to NEWNAME t NAMEFIELD and did not
work, so I tried your way is the same show a empty combo box
Click to expand...
Click to expand...
 
Bruce never mind, worked very well, thanks. Can you help me and another matter?
I have a form(from 1 tables)that shows
STUDYID
STUDYNAME
BUDGET
and a subform (from a table) that shows:
Mediaexpenseid
Studyname
Expenseamount.
I am triyng to habe a field that shows balance and totalexpenseamount,
I did what someone helped me with :
To get the total expense create a field and in the source of the field write

=[Mediaexpenseid]+[Expenseamount]
If the subform is a single form, that has only one data then you can create
a field on the form and the source of that field write
=[BUDGET]-nz(Forms![MainFormName]![SubFormName].Form![Mediaexpenseid] ) -
nz(Forms![MainFormName]![SubFormName].Form![Expenseamount] )

If the sub form is continues form, that has few records, then create in the
footer of the sub form two fields, to sum the expense, make the fields not
visible.
write in the source of each on of them
= sum([Mediaexpenseid])
=sum([Expenseamount])

create a field in the form like mentioned above but write in the source of
the field

=[BUDGET]-nz(Forms![MainFormName]![SubFormName].Form![SumOfMediaexpenseid] )
- nz(Forms![MainFormName]![SubFormName].Form![SumfExpenseamount] )

The problem is the balance is showing is wrong: it adding my expenseid's
number to my sumofexpenseamount and is not right. Can you help me?? Thanks
 
Back
Top