Search results

thanks that worked perfectly! I think i'd tried practically every other example i could find this morning!

right I have searched and searched the forum but obviously this isnt as simple as I thought it would be! I have a main form called "frmAllStudents" based on a query called "qryAllStudentsMainScreen". The unique field in all forms is Admission Number. I have on this form a data-entry subform...

Thanks that was very helpful! Will give it a whirl and try that

I have a form with a subform attached. on the Main form you select the student then you enter letters sent out in the subform. Basically there may be 22 letters going out all the same just to different students. so the standard letter type will always be the same as will the date field I know...

:) :) :) : :) :) :) :) Thank you very very much!!! i'd kiss you but you live in yorkshire! thanks for taking the time to look at it again for me

sorry no i meant the copy i put on origionally! not you sorry hon i didnt mean you at all... i'd stripped the database wrong and it wasnt working properly... any help given is very very much appreciated!

"I take it thats tomorrow's task?" - it was all working yesterday :( now i feel like crying

I downloaded that copy you attached and it seems to be totally botched up... going to attach another copy... i think my origional was messed up but the list still isnt just showing the letters sent to a particular student and now when I click on something from the list it doesnt open up a record...

remember i didnt ask anything about the rest of the form???!! Arrrgghhhh Panic-stricken now... whats wrong?? you have to tell me now waiting on tender hooks noose already round my neck!

I did it origionally from the wizard.... and its not working.. I just assumed it had worked after all if you put a subform in etc it seems to work... just I have never had to use a listbox before

tried to put that in the query but it didnt work.. I've attached a copy of it just incase anyone can shed any light on it...

I have a form with a subform which has a listbox on it which lists all the letters sent home to a student. However despite the subform being linked by admission Number the list box is showing all records and not just the ones associated with the student. I know this is going to be really...

I have a form which has a listbox listing all the letters a student has had sent home. Basically i want to be able to click on a letter in the list box and for a popup form to open with the record details. However it just brings up a blank record. The list box has a unique field called...

got it to work I took your message a little too literately and put me.frmPerformance.setfocus first. Then docmd.GoToRecord,,AcNewRec but i realise now that the "first" was an instruction to me not coding! I am having a really bad week! It works brilliantly thank you!

put it on the main form where?

I have a subform that I want to automatically go to a new record but I dont want a data entry screen as they need the previous as well. I've tried putting DoCmd.GoToRecord , , acNewRec on the form open command that doesnt work.. tried it on the onload().. I thought this was going to be really...

that was probably my fault rather than it being a problem with the origional forms... i found out what the problem was some code was left from frmstudentperformancepoor which i had copied to make the second form frmstudentperformancepoorprevious in the onload() which was messing it all up...

its a number field but i tried DoCmd.OpenForm "frmstudentperformancepoorprevious", , , "[popUPID] = " & Me.StudentPerformanceID and that did exactly the same with giving me a blank record I've attached the database sorry took so long was so Big! go to student Allen Raymond and you'll see...

hang on its massive I'll strip it and send it over

tried the other code suggested.. back going in circles tried that it works the first time... but if you go off the screen and come back again.. and try to open the other form it comes up blank