Ok thanks that works, now i have a slight problem from here... though i know its not major.
How do i get the list to lookup the query each time i change record on the form? As its not updating the subform when i change the main form from T1001 to T1002 for example.
Kev
:cool:
Ok, this kinda involves a number of things so i wasnt too sure where to place this thread. As its all based around a form i figure thats the one for me.
Ok i am trying to create a tilling system for my college coursework and i have a good idea on how the data will be entered with the use of...
Update: i am being an idiot, i just noticed that the button wizard does exactly what i wanted it to do hehehe.
Thanks anyways, i managed to get it working without the wizard then noticed it lol, typical.
Kev
:cool:
Ok thanks, here is what i just found, is this correct?
DoCmd.OpenForm "Problems", ProblemID=" & Me.ProblemID#
Im pretty sure i got the where conditions wrong, this is the part i need help with i think.
Thanks for the help.
Kev
:cool:
Right guys and girls i have a problem. I have looked at some threads here which talk about this sorta thing but im not too sure if its what i need and to be honest i dont understand it fully.
Here goes...
I have a form which shows jobs for a motorcycle workshop. A subform is created which...