salibes
asked on
Auto update upon insert
Is it possible to have access auto update field values based on what the user has already input. For example, if there are three fields: A, B, C -> user is asked to input A and B, and have access then automatically update the value for C as the concatination of the string A+B. Is there anyway to run an auto query as the values are inputted. This of course works in excel, but does it in access?
On an unrelated note, is there a way to use the date field for only month and year or would that have to be text.
Thanks
On an unrelated note, is there a way to use the date field for only month and year or would that have to be text.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You could put a query in the control source for the listbox and use A and B as parameters of that query. Make sure to use the [xxx] when refering to A and B controls in your query. This would be if C resides in a table somewhere.
Another way to change the contents of listbox C based on A and B would be to write a subroutine that populates the list box useing listbox.item.add (I beleive that is the syntax). Then use that sub as the change event on A and B.
Hope this helps.
Another way to change the contents of listbox C based on A and B would be to write a subroutine that populates the list box useing listbox.item.add (I beleive that is the syntax). Then use that sub as the change event on A and B.
Hope this helps.
ASKER
Thanks,
but , I want to have a value show up in a text box , not listbox. if in a listbox i want it to become default selected. I'd rather have it in a textbox, is this possible?
but , I want to have a value show up in a text box , not listbox. if in a listbox i want it to become default selected. I'd rather have it in a textbox, is this possible?
ASKER