This is the first time I am join this web & forum. My name is Angie.
I have face some problem for Ms Access. I would like combo box to be auto change when date due. Eg: combo box name: Status. Inside have info such as Expired, Active, Ignore. This info will base on the text box name txtenddate. When the date is due, (eg:today:09 May 06), combo box will auto change the status from Active to Expired.
Any VB code can be used. Thanks.
Hope to heard from you soon.
Last edited by angie_oet; 05-09-06 at 05:37.
Reason: No body reply me
I need to reword your request to see if I understand:
When a record comes up, you want a text box to display Expired, Active or Ignore depending on the value in txtenddate.
If this is what you need, the code goes in the event "On Current" an the code is along the lines of:
Select Case Me.txtenddate
Case <= Date()
Me.cboStatus = "Expired"
Case > Date()
Me.cboStatus = "Active"
ME.cboStatus = "Ignore"
Hi Angie and "Welcome to the Forum"
Just out of curiosity and see if I'm reading it right. You check me on this too TC. But, you are using a TextBox to feed info to a ComboBox? You're not using to ComboBox itself to select information? I thought you would use it the other way around. But any rate, wouldn't it be just as easy to use two TextBoxes then? Again, just trying to see what's going on here too.