Default Value from Another Table

[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!

 

[strive4peace]

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
*

 

[paul23]

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

-------------------------------------------------------