Requery problem sub select form problem I think (1 Viewer)

Hi there,

I have a bit of a problem here.

I got working on a most workable solution for a form, now I will explain the situation before I explain the problem.

I have a ink cartridge codes table, with an id field in there which relates to a manufacturers table.

As I worked out there would be literally 1,000's of entries eventually in the cartridges code table, and resulting the user having to scroll down for ages to find the one they wanted to use, I thought about making an unbound select box prior to that, which limits the cartridges as per the 1st select box.

Like selecting Brother brings up the LC02BK cartridge and for Epson say the IP3200 or whatever is an epson one etc, selecting Epson wouldnt bring up the LC02BK in the 2nd select field.

But I have a problem with this, when the user closes the form to go and query the database or reopen it manually, it looses that information.

I think this is because of the 1st select box, for the manufacturer.

How would I go about making it keep its value rather than just clearing it, as if it was an empty select box?

Bit stuck on this, so any help is greatly appreciated.

Thanks once again in advance,
Jeremy.

j.smith1981 said:

But I have a problem with this, when the user closes the form to go and query the database or reopen it manually, it looses that information.

Click to expand...

not sure what this means. there might be some info on this thread that could help:
http://www.access-programmers.co.uk/forums/showthread.php?t=187193