Hi Guys,
Basically I have a form with some textboxes that you enter information in. The form has a listbox that runs off a query with a list of items displayed in the listbox from the table. These items in the listbox need information entered which the user does manually in the textbox. To make it easier, the first value in the list box column auto populates in one of the textboxes as it is a unique value for each entry. However, I have noticed that anytime I click on the list box value to autopopulate the textbox, the date value is not entered in the table alongside the other data I input manually. The date value is not in a textbox but is in the table and is meant to have a value of =Now() put in everytime a value is entered in the table so we know when the data was entered.
Any reasons for this and how I could fix this problem?
Basically I have a form with some textboxes that you enter information in. The form has a listbox that runs off a query with a list of items displayed in the listbox from the table. These items in the listbox need information entered which the user does manually in the textbox. To make it easier, the first value in the list box column auto populates in one of the textboxes as it is a unique value for each entry. However, I have noticed that anytime I click on the list box value to autopopulate the textbox, the date value is not entered in the table alongside the other data I input manually. The date value is not in a textbox but is in the table and is meant to have a value of =Now() put in everytime a value is entered in the table so we know when the data was entered.
Any reasons for this and how I could fix this problem?
