By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,285 Members | 1,691 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,285 IT Pros & Developers. It's quick & easy.

Populating one control depending on value of another control

P: 4
I need to create a form where one fields value will determine another fields value.
example field name [status] is "Closed" then field name [Closed Date] will automatically populate with the current date.
any help would be greatly appreciated.
Aug 9 '07 #1
Share this Question
Share on Google+
4 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
I need to create a form where one fields value will determine another fields value.
example field name [status] is "Closed" then field name [Closed Date] will automatically populate with the current date.
any help would be greatly appreciated.
Hi biffyp

Welcome to thescripts.

I am moving this question to the Access forum.

Mary
Aug 9 '07 #2

missinglinq
Expert 2.5K+
P: 3,532
Please remember to provide a meaningful Title for any threads you start! This helps to ensure that other members, and also the general public, will have a better chance of finding answers to any similar questions. It is difficult for the experts to answer questions when there is not enough details provided to understand the problem.

Please take the time to read the Posting Guidelines, paying particular attention to Give a clear title to your question.

http://www.thescripts.com/forum/thread559246.html


Thank you and Welcome to TheScripts!!

Linq ;0)>
Aug 9 '07 #3

P: 5
Open your form in details and go to properties of the Status field
In the AfterUpdate event of the Status put me.ClosedDate = now()
Aug 9 '07 #4

P: 4
Open your form in details and go to properties of the Status field
In the AfterUpdate event of the Status put me.ClosedDate = now()

it worked thank you. I am trying to teach myself VB and SQL . I really appreciate the help
biffyp
Aug 10 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.