Been having a little trouble with getting my SQL query to get data from a form to run a comparison.
Basically I have an ordering system for a company and each order has to be authorised by a member of management. However who can authorise it is based on the manager's authorisation level (number e.g. currency)
What I want to do is on the order form have a drop down list which shows the users that can authorise the order, and then whoever is placing the order can select the person that they wish to authorise it.
The usernames are stored in Usertbl - Username
The auth level is stored in Usertbl - AuthLevel
The form I'm working with is [New Order Entry Form] and the total cost of the order is held in Text41 on that form.
What I currently have is this:
FROM Usertbl, [New Order Entry Form]
WHERE [New Order Entry Form]![Text41]<=Usertbl.AuthLevel;
Are you physically changing the value in the textbox? The after update event will only fire in that instance. If it's changing due to the change in some other control, the after update event doesn't fire. Can you post the db?
Well, you need to find some event that triggers the change in the textbox, perhaps the current event of the form where they're entering details. Or you might try the got focus event of the combo, which would fire when the user entered it.