Recent content by Goochie

Got it! Well done, thank you very much. Some times you can't see the wood for the trees. Much appreciated.

Well there is no doubt that this is working on the demo I gave you for Customers, but when I try the exact same syntax on my live version it doesn't work. Also, on the demo I tried using the same principle for the Employees form but it doesn't work. Are you sure there wasn't something else you...

Well that works brilliantly! What did you change?

Here you go. ResponsePortal is the Navigation form. Customers and Employees contain the combo boxes with the problem.

That makes sense. I changed the form name to NavigationSubform and it runs, but no differently to the original issue. I still can't get that first record. It seems to me the SQL query is fine either way so it's got to be somewhere else interfering with the result.

Worked fine by itself using your first example but when I modified it and ran it inside the Navigation form I got the following error.

SELECT CustomersExtended.CustomerID, CustomersExtended.CustomerName FROM CustomersExtended WHERE (((CustomersExtended.CustomerID)<>Nz([Form]![CustomerID],0))) ORDER BY CustomersExtended.CustomerName;

Thought it might help if you saw a picture of what I am doing. You see the combo box has 8 records showing, including the current record. Record no. 1 is not in the list but it should be. If I open the same form independently from the Navigation form I still only get 8 records BUT unlike when in...

It's a query.

No it is definitely a number.

Just tried that. The combo box has no records at all.

The row source criteria is <>Nz([Form]![CustomerID],0). This remains the same whether the form is viewed inside the Navigation Form or by itself.

I have two forms working perfectly when I open them directly, but when I use them inside a navigation form I have the following problem - A combo box allows me to choose a customer (or employee in the second form), all works fine, BUT after selecting a new customer I cannot use the combo box to...

So pleased to be here. I have been reading some very helpful posts and am looking forward to making this site a regular haunt. I used to develop a lot of Access databases about a decade ago and have just got back into designing a new Customer Response Administration Portal (yes I call it CRAP!)...