Recent content by KingKong

Ghost, I don't know what your Macro actually does look like...but you could use a couple of Queries in your Macro like an Update Query and an Append Query to update your order table with the temporary data and use an OpenTable (temporary order table) and then 2 RunCommand statements (first...

relationships are the key I hope this is what you're looking for? check the db_example (attachment) ;)

??? I'm a bit puzzeled, perhaps you could post your db so I can take a look at it? Grtz, Peter. PS. I'm using Access97

Have you looked at the properties of the cbo, to make sure that it's not locked?

Have you tried to requery the combobox?

Try this.... James, Couldn't figure it out myself.... ...but I think I found something! Try this link: http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q166/6/34.asp&NoWebContent=1 It's an example of Filter by Form. Grtz, Peter.

James, I tried to take a look at the db you've enclosed, but couldn't open the file. Which version of Access do you use (A97,A2000,..)? Grtz, Peter.

Oskar, I think you will have to do some redesign on your tables. You've linked your tables via the PK (ID), what you really want to do is link them through use of a FK (Foreign Key). Grtz, Peter.

Mik, Check this thread on customizing error messages: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=36782 Credits go to ghudson. Grtz, Peter.

I h*te double posts, that's actually one I've forgotten :D!! (check this thread at The Watercooler) http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=199747

warco, Try this thread for 'autonumber': http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=40609 And this for 'default value': http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=18210 Credits go to Talismanic and WayneRyan. Grtz, Peter.

kingsgambit, check this thread: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=50626 and then this one: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=44668 Grtz, Peter.

re-direct... Oracle, Check this thread: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=47911&highlight=limit+AND+to+AND+list Don't thank me, thank Mile-O-Phile. Grtz, Peter.

onedsla, Try this thread, you'll will find a sample db (manytomany.zip) courtesy of Pat Hartman. http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=40821&highlight=manytomany Grtz, Peter.

Hi zym1ne, I've attached a simple db to show you how to do this (well that is off course if I got your question right;) ). It's just a form which has a combobox on it where you can select the DealerID. Once you've selected the ID, the details are shown in a sub-form. Open frmDealersInfo to...