I dont know access or any other database type program very well. I've got a very simple table with corresponding form. On the form I have a text box that displays the current logged in user. This text box is populated using a function. How do I get the user id info that is populated in the text box written to the table for the record each time its updated? Any help is appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Updating table from form
- Thread starter shazbot
- Start date
TheAceMan1
Programmer
How are ya shazbot . . .
[blue]Your Thoughts? . . .[/blue]
See Ya! . . . . . .
Be sure to see thread181-473997 [blue]Worthy Reading![/blue]![[thumbsup2]](/data/assets/smilies/thumbsup2.gif "[thumbsup2] [thumbsup2]")
Also faq181-2886 [blue]Worthy Reading![/blue]
You could set the [blue]Default[/blue] property of the textbox to the user! All added records would have the user ID or Name!shazbot said:
[blue]Your Thoughts? . . .[/blue]
See Ya! . . . . . .
Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]
- Thread starter
- #3
TheAceMan1
Programmer
shazbot . . .
Textboxes have a [blue]Default[/blue] property. When this property is updated to the [blue]current user[/blue], each new record will have that value automatically inserted. If the textbox is bound the value is automatically saved to the table when a record is saved.
Instead of
[tt] Me!TextboxName = YourFunctionName()[/tt]
You should have
[tt] Me!TextboxName.DefaultValue = """ & YourFunctionName() & """
[blue]Your Thoughts? . . .[/blue]
See Ya! . . . . . .
Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]
Textboxes have a [blue]Default[/blue] property. When this property is updated to the [blue]current user[/blue], each new record will have that value automatically inserted. If the textbox is bound the value is automatically saved to the table when a record is saved.
Instead of
[tt] Me!TextboxName = YourFunctionName()[/tt]
You should have
[tt] Me!TextboxName.DefaultValue = """ & YourFunctionName() & """
[blue]Your Thoughts? . . .[/blue]
See Ya! . . . . . .
Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]
- Thread starter
- #5
TheAceMan1
Programmer
shazbot . . .
Be aware ... the [blue]DefaultValue[/blue] only needs to be updated once per user. This makes the forms [blue]On Load[/blue] event prime for your function.
[blue]Your Thoughts? . . .[/blue]
See Ya! . . . . . .
Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]
Be aware ... the [blue]DefaultValue[/blue] only needs to be updated once per user. This makes the forms [blue]On Load[/blue] event prime for your function.
[blue]Your Thoughts? . . .[/blue]
See Ya! . . . . . .
Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]
- Status
