Search results

sending a sample Here's a sample of my database. Try typing 33112-2 into Kataloogi # field (first and primary key field) and you see subform will be filled only and no other data. And how could I edit?

Yes, I selected third option and so on. When I typed something existing into that field nothing more happened, no autofill.

Weird, no autofilling. Do I send you a sample of my database, Graham?

I have tried this combo box version, won't work. What I want is all fields filled with data after entering a value in Catalogue # field and then edit them.

How can I edit existing data through a form? When I enter a value to Catalogue # field (this is primary key field) then all related data should be visible (it means something autofill stuff) and no '...would create duplicate values...' messages. Any code part or can be simplier? Thanks.

Wasn't help BUT I accidentally replaced comma with semicolon and voila! All expressions work! And for addition, Access seems not to care about comctl32.ocx. Before semicolon I checked references and Common Controls was disappeared. So, the whole thing was about comma-semicolon? But why? Are...

Was missing but no help. Still says the same.

Sorry, one bracket missing, now =Left([Country], 3) but that doesn't matter - the same result as above.

Access gives me a syntax error every time when a expression contains a comma. For example, using =Left([Country), 3) Access reports omitted an operator or an operand, invalid character or comma, or text without surrounding it in quotation marks. Where's the mistake, I exactly copied syntax from...