Replies

did you requery the second combo box when you clicked in the first combo box

try this
http://support.microsoft.com/support/kb/ar…=gn&FR=0&qry=97 no license&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=ACC97
sorry but i don’t know how to make the link clickable

yes it can be done
remove the macro from the on click event
now click on the three dot button at the left on the on click event then choose code builder
now enter the name of the unbound textbox like this
text1 = “part number”
hit enter and on the next line run your macro
docmd.RunMacro “macro name”
this will fill the text box with the part number and then run your macro
don’t give up this is easier than you think
it’s just a different way than you are use to
if you want send me a zipped db with this form in it and i will show you what i mean
if you want send to jwcurry@cafes.net

i was just re reading your form setup
if you wanted you could place three listboxes or combo boxes in the form one for part number one for length and the other for color that way one query would work for all part numbers and and unbound textbox for each list or combo box would let you know all the information when the “no stock” came up
just a thought

ok i taking it that you have six different buttons for the part numbers
if this is correct
place an unbound textbox on the form
then on the onclick of the button put the part number in the text box
like this
text1 = “the part number”
the part number will stay there until you remove it or replace it with another number
also if you wanted you could make a list box for color and the user wouldn’t have to type that
let me know if any of this works for you

is there a command button for each part number
if not how do you tell the macro what part number you want

have you tried NZ
NZ[field name]

is the part number still in the field even though there is no stock
also how do you start the query from a button a list or combo box or what

is the part number in the criteria field of the query if so why not set a control for this field

Thanks for your reply Charlotte
I tried removing the references
i removed every one it would let me
still no good
so i uninstalled 2000 installed 97 then reinstalled 2000 again
still no good
so i converted the database to 97
worked fine
converted back to 2000 and now the database works just like it did before the crash
many thanks to you Charlotte and to you Rupert
your help is appreciated more than you could know i just wish i really knew what happened
i’m thinking something got corrupted in the database but don’t know for sure
thanks again

no i keep getting this message

Thanks for trying and yes i have tried detect and repair i’ve reinstalled access and ME both
i went to work and looked on my computer there to find no vba6.dll on that machine. i don’t know whats going on but access won’t let me do any thing i just keep getting the same message
“FILE NOT FOUND VBA6.DLL”
so any help would be very much appreciated
thanks

instead of send to back or bring to front
you can make the control visible or invisible
text1.visible = true or
text1.visible = false
HTH

Have you tried sending the image to the back in design view and making the controls invisible
untill needed

try looking at SendObject
in help it should do what you want