MS ACCESS VBA If Form textbox value in table and date is not null then
Need to write VBA to determine if a textbox value is in table then . . . update table
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
VBA doesn't directly access tables. You would do this by creating an update query that selects the record you want to update if the value is null and sets the value to whatever you want.
I'm guessing that you are making this harder than it needs to be. Are you not using a bound form?
I'm guessing that you are making this harder than it needs to be. Are you not using a bound form?
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER