Default Value from Another Table

  • Thread starter Thread starter MollyDog8
  • Start date Start date
M

MollyDog8

How do I set a default value for one field with a value from a field in
another table, if the second value is selectable? In other words, the value
for field Directors.programs is user-selectable. How do I make the user
selection in this field the default value for Programs.directors?

Does this make any sense?

Thanks!
 
Hi Molly,

you cannot do this at the table level -- you have a lot more control
when you use forms to enter data.

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*
 
in the code you could use the after update event of the text box to do something like

Private Sub textbox1_AfterUpdate()
textbox2 = textbox1
End Sub

-------------------------------------------------------
For your FREE Access beginners ebook

http://www.access-databases.com/ebook

-------------------------------------------------------
 
Back
Top