Search results

I made this simplest code so when the form opened it would go to the new record but sadly this simplest code in the world doesn't work... :( Private Sub Action1_Open() DoCmd.GoToRecord , , acNewRec End Sub On the form property, I set Open to Event Procedure but it is not working...

Thanks a lot folks! It works!! Have a nice weekend!! :D

Like this?? but it resulted like this....

Thanks KenHigg... Is this a column in a report you are talking about??

I am writing a database to record staff training records each training record will have two costs involved: cost of the course and no show cost I would like to write a query which if attendance is set to yes, then the record would show the actual cost if the attendance is set to NO, then the...

Thank you all for the help but for the unknown reason it is still not working. but since JR has provided another solution in the VBA code area, I will go for the copy and paste and revisit this issue later. Thanks again for all the help that you guys provided. love you all!!

Thank you JR. It wasn't a naming issue... quite strangly, once I reverse the order: student_name first then student_number (only did this as to test if it only takes the first line syntax) then it just worked!! don't know why but it is indeed working!! thank you so so so so so so so so much!!

oh my god!! the parent.parent worked!!! BUT!!!! Only student number was copied and pasted... I am not sure what happened... in your test database, were both fields copied and pasted?? (I will have a look at the link you enclosed...I am covering the front desk and working on database at the...

oh...it's still showing #Name?

Dear Janar with respect I am sure the code should work fine... the reason it didn't work in my form is .. (I can see more people shouting this is bad practice) the subform you see in the graphic actually contain another subform (so it's a sub-sub-form) I had to do that so the txtsearch vba...

Thanks JR...it looks like the code I need unfortunately it doesn't work is it possible to make the parent form specific? for example: Private Sub cmdtrans_Click() Form![Log]student_Number = Me.Student_Number Form![Log]Student_name = Me.Student_Name End Sub only know very little...

previously it shows #Error .........:(

Thank you Rabbie Now the error message is gone but returns with #Name? what does this mean??

I have looked at the text book and checked many times, and I am sure I am doing something wrong.... I even created a simple form just to test it out and it is still not working.... can anyone see the mistake in the attached graphic? :(:(:(

the subform is simply a *sub-form* and there is no relationship built with the parent form. What I wish to do is, the parent form will be adding a new record, but as we are getting more repeating/returning service user, I would like the function when I enter the student number, it'd search if...

oh it's only the descriptions - the fields are actually both called Student_Number...

The other possible solution is to have a Dlookup with If statement for the MMU ID field. (i.e. if there is a matched data then populate the student name, if not leave it blank...) either way as long as someone knows please help....:(

HELP!! get subform data to the main form or Dlookup with If statement Dear all I have a form which contains a subform (see attached graphic) I would like to have a bottom created that on click it will copy the student number field and student name field to the main form (as shown in the...

I put this script as *control source* in the Student_Name field DLookup("[Student_Name]", "[Ticketing_Data]", _"[Student_Number]='" & Forms![Log]![Student_Number] & "'") I was hoping that it will then look for the name stored in the Ticketing_Data table which mataches the student number...

sorry...but I am lost... shall I start over again? The form wrote to a query "Log_data", which wirtes data to two linked tables "query" and "ticketing" - and only the table "ticketing" contains student numbers and student names, where many students have more than one visting record (thus...