a few questions..

[keybearer]

a little help please..

1. is it possible to enter a date with the format :
"MonthName-Year" such as "June-03"? if so, how do i do it?
2. I have a multiple select listbox, how can i empty the selections made when the listbox is disabled or after it lost focus?
3. I have an option group with 2 options.. when i select an option, an action query is triggered and a value in a textbox is transferred to another table.. now i want to change the value in the textbox, but i have to click the other option first before selecting the same option for the value change to be transferred..
how do i make the transfer with just a click on the same option?

dats all.. thanks in advance..

 

[WayneRyan]

key,

If you enter a date in that format, Access will have have to make
a decision as to what the day components is. It does not mind
making a decision on the time "12:00 AM". I honestly don't know
what it would do when just given a month and year.

You can set its rowsource to nothing and requery it. Then set it
back to the appropriate query or table.

I don't understand your third part.

Wayne

 

[keybearer]

sorry for not replying earlier.. i was away for a while..
about the third part, i'll explain it in more detail..

i have a textbox containing the home address (HomeAddTxt) and another containing the office adress (OfficeAddTxt). Then i have an option group box that contains 2 checkboxes to select which address is used as the mailing address.. if the 1st checkbox is selected, an action query is triggered and the value in the HomeAddTxt is transferred into a table and if the 2nd is selected, the OfficeAddTxt value is transferred.

now let say the checkbox is already selected to the 1st checkbox and i need to update the home address value.. after i change the value in HomeAddTxt and i clicked the 1st chkbox again, the action query will not be triggered. I have to select the 2nd chkbox and then select the 1st one again..

FYI, my code is in the afterupdate section.. i have tried putting the codes in afterchange section but to no avail..

 

[WayneRyan]

key,

Why can't you, after you run the first append query, clear the
checkbox? Me.Checkbox = False.

Wayne

 

[keybearer]

the option group has another purpose, that is to show which address the person will be using as his mailing address..