Recent content by smartslingaro

The progress note has it's own primary key, and I want the student id to prepopulate based on form where it clicked from. Maybe I set form to open to new record and this won't work? no, need it to be new record, just with student id prepopulated from previous screen.. hmmm....

Private Sub Command124_Click() DoCmd.OpenForm "Progress Note", , ,"[Student ID]="& Me.[Student ID] This opens the form, but does not link it with student id

run time erro 3075 syntax error in string in query expression '[Sutdent ID]='208'.

what does the acNormal mean/do?

no it is an auto number primary key on the first form and linked to second form/table by same field/number

Do the capitals matter in general? that didn't work. The first line is highlighted by the debugger.

Hi, I have a form that I want to open based on record in current form. 2nd form is different table, linked by primary key in first. Need form to open with primary key on first form, like an autofill of the field. Keep getting a syntax error with this code: Private Sub Command121_Click()...

I have been putting them back one by one.. Haven't found the issue, but I think it was a macro somewhere. I had tons of crap in there as I am still in the process of building. It was good to strip it down. Thank you. Before I go to much further, I need to figure how to open a report filtered...

Thank you.

thank you for the exercise of copying the db. one of them has all the data, but not the other forms/queries/macros. probably a macro screwing it up., and they don't really seem to work now that i've copied them into newer db. Is that common? normal?

your right, wonder why it works there on test db

error message screen shot

When I click on the combo box for a name I get the error and it doesn't fill my form. Working on getting you screen shot.

what is the easiest way to have a search bar on a form that brings up the record in that form.

here is a copy of test... oops telling me it is too big? ok think i did it, I made it smaller and left out most of it. but this is the part I need first. should be simple, no?