Search results

Ok. Then from scratch. answers below in blue Forms 1 and 3 open form 2 On form 1, 1. What is the form name? frmcontacts 2. What is the name of fld you use the primary key? id 3. What is the name of the surname fld? surname On form 3, 1. What is the form name? order summary 2. What is the name...

Ok. Then from scratch. Forms 1 and 3 open form 2 On form 1, 1. What is the form name? frmcontacts 2. What is the name of fld you use the primary key? id3. What is the name of the surname fld? surname On form 3, 1. What is the form name? order summary 2. What is the name of fld you use the...

I don't think it's possible as there are all sorts of permission/security levels which I don't know how to take off.

but how do I get it to automatically open the record I've just clicked on rather than specify an actual surname?

Yes I know how to do that

sorry I should explain that I am not a programmer and only know the basics of access most of which I have picked up as I go along. I have never written anything in code as I don't know how. That's why I used a macro as its the only way I know of doing things. The macro is opened when you...

Thanks for help - I have changed the code for form1 but on form3 it is a macro to open form2 - where do I put the code? I tried putting it in the where condition (which already has a code in) but it doesn't work.

maybe I didn't explain this properly. Form1 has a command button to open Form2. Form3 has a double click to open Form2. On Form2 there is a field in the header which says: =[Forms]![Form1]![surname] It is this which I am trying to change not anything on Form1 or Form3. so I want it to take...

thanks but when I change it it then doesn't work from the first form.

Yes that's right - it's stored in frmcontacts which is where it is getting the info from if you click on the command button

no it's the control source

Hi I have a form which is opened by two methods - one from a command button on "frmcontacts" form and two from double-click on "ordersummary" form. At the moment there is a field which populates from the command: =[forms]![frmcontacts]![surname] which is fine if you enter it from...

have emailed it - hope it comes through okay

File won't upload due to being too big - I've tried deleting most of the content but I can't compact it due to permissions - strangely it let me compact it the other day. I think I'll have to give up for the time being. Thanks for all your help though. Fugly

whoops - it didn't upload the file although it said it had - I'll have to try again tomorrow - thanks for your help - I'll be in touch

Okay that seems like a good idea - I've attached a copy here (hopefully) - just to clarify - the form is "Production Order Summary" and the report is "Daily Job Sheet" and the double-click field is "Surname". I want the daily job sheet to be populated with all the relevant information not just...

it now asks for "enter parameter value" "txtsurname" then enter parameter value "forms!production order summary!txtsurname thanks

It's definitely a main form

yes - with brackets and ! exactly as you said :confused:

sorry still no joy it now says "enter parameter value" forms!production order summary!surname (production order summary is the name of my form).