Start Ms access bound textbox not updating

Ms access bound textbox not updating

In Microsoft Access 2003/XP/2000/97, what VBA code do I use to set the value of a textbox based on the value of another textbox?

Hi all, The database I am making is essentially for data entry of files and which boxes they have been placed into for storage.

I have multiple textboxes on my form but I am only focused on a couple.

Microsoft is conducting an online survey to understand your opinion of the Msdn Web site.

If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.

I have tried putting the following combinations of code in the before update, after update, on change, on lost focus events of the unbound textbox. It sounds like you have a fair amount of code being run on Open of the Form, some of which relies on the value of Location ID. Have you validated that the value is not being changed?

Value, maybe after you update the value of Location ID. It sounds like you have a fair amount of code being run on Open of the Form, some of which relies on the value of Location ID.

The value of a Text Box or Field can be a Null or a Zero length string, which evaluate differently and a Null does not equal a Empty string.

Both of the ways Seth and I build the expression force the left side of the expression to be a String and then evaluate from there. It's going to be complicated to explain but I'll give it a go and hope you guys understand what I mean.

I have a Text Box that uses a Date Picker, with a Short Date format, to select a date to be used as criteria within a query attached to a List Box to select records from a table for a Date/Time (Short Date Format) field equal to the Text Box value.

My question is how to get the form to refresh the List Box query after the Text Box has been updated.

So with this same data entry form, when the user enters into the textbox a location that is not already in my tbl Location, a dialog box opens up giving the user the option to add the new location to the table or to select an existing location from a list box. The first function below is what I am using to determine whether or not the entered location already exists in the table.