Can I use the value of a field as predeterminate value of another.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

elyonja - 30 Jul 2007 14:32 GMT

I am making a table to know who is working in each surgery in a heath center.
For each day, I have a field "owner" (of the surgery) and another "working"
(the one that really works that day there). But the majority of the days, the
"owner" is who works in his surgery, so I want to establish the value of
"owner" as predeterminate value of "working" . Is it possible?
Thank you

Reply to this Message

Roger Carlson - 30 Jul 2007 14:52 GMT

Not directly in the tables. You could do this in a form by making the value
of one text box the default value of another text box.

Signature

--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

>I am making a table to know who is working in each surgery in a heath
>center.
[quoted text clipped - 5 lines]
> "owner" as predeterminate value of "working" . Is it possible?
> Thank you

Reply to this Message

Wayne-I-M - 30 Jul 2007 14:56 GMT

Open the form in design view
Right click the form (outside the detail area)
Open propertiy box
Select the Event column
Select the OnLoad event
Select build option (...)
Select code
Use this

Private Sub Form_Load()
Me.working = [Owner]
End Sub

Change the control names to what they really are

Good luck

Signature

Wayne
Manchester, England.

> I am making a table to know who is working in each surgery in a heath center.
> For each day, I have a field "owner" (of the surgery) and another "working"
> (the one that really works that day there). But the majority of the days, the
> "owner" is who works in his surgery, so I want to establish the value of
> "owner" as predeterminate value of "working" . Is it possible?
> Thank you

Reply to this Message