Recent content by AOMCprog

As I said, that was just an attemptto link this query with another query that had the same value of "Link" in it. I have removed that expression, but I still get the same error message. Here is the new SQL: SELECT DISTINCTROW Orders.Orderer, Orders.[Order Type], Orders.[Order Date]...

No, I called it Expr1. Don

Okay, now I see it. That is my attempt to link that query to another query. I'll remove that expression from the query and try again. Thanks. Don

I don't see any red bolded expression. Don

Sure, here you go: The begin and end dates come from the CalendarForm. Don

Hello, I have a form where the user inputs a date range and that date range is the filter for a query. The query works fine, but here is the problem. On a form based on the query, I can display the query results in text boxes (one record at a time), but I cannot display the query results...

It works. Thank you vbaInet!!! Can you tell me what the key was to making it work for future reference? Don

Okay, here it is. Low level (locked field) = "Tech", high level (unlocked field) = "RPh".

I have no problem doing this, but how?

Okay, just as I suspected, the mytxtbox.Locked = (Nz(Me![FieldNameOfLevel], "") = "Low Level") is looking for "FieldNameOfLevel" in the table that the form is based on and not my query that I use to obtain the person's name and level. I changed the field names so they were not the same in the...

Changing it to that gives me a compile error:, syntax error.

Run-time error '94'. Invalid use of Null My form uses my "Orders" table which contains all the records that are being created and has a field called "Order Type". My "Query Orderers" which goes against my "Orderers" table which contains the list of people with their access level also has a...

Doesn't seem to like that Me! command because the Form is using a table and I am using a query to obtain the person and level. I think I need to somehow refer to the non-form related query.

Okay, here is what is happening. The msgbox Mylevelcombobox.Value in the On Current event portion of my form only works when the form initially comes up, and value of the combo box is the person's name. That is because the level combo box is bound to the person's name but set to display the...

Clicking the elipsis button that appears when I put the cursor inside the row source property of my locked combo button just brings up the design view of my query, which does not have an ID field in it. Hey, appreciate you taking the time to help me with this. It must be late in the UK, and...