Search results

Forget it. It's right below page header footer, DUH! When in design view right click in the details section and you can click on it there to bring them into the form. Thanks anyways.

it's not in a report that I want to see them. It is in the form in form view.

Where do I turn on my Form header in Access 2007? It's been awhile but i thought there was form header and page header in a form, right? The fields I have put in my page header don't show up in form view because they are in the page header, right? But then that may also be my problem.

Hey, that worked. master: bpid;textbox16 child: bpid;[Alt_id] Nice! Thank you.

I linked sub2.bpid=main.bpid and sub2_slt_id=main.textbox16.value textbox16 control source is set to sub1.alt_id This form is going to get used to rgister company's at an event In the main form the client searchs for the customer and bring into the form the info. If the info is incorrect, or...

Sorry, I'm not doing something right Private Sub Form_GotFocus() Forms!Register!2011_attendee_contact.Form.Requery MsgBox "Event fired" End Sub

Do I paste that into an event? Which event OnGotFocus?

I have 2 subforms in my main. in Sub1 I have a field alt_id and it's set as an auto number. I placed a text box, Text16, in main and set it's control source to be sub1!alt_id. In Sub2 i linked main.bpid to sub2.bpid and main.text16.value to sub2.alt_id. However i need to refresh sub2 in...

Thanks Bob works like a champ.

That was it 999999. Thanks. I'll try to figure out the null statement.

I also changed it up alittle in put in the sub_form property as Private Sub Form_BeforeUpdate(Cancel As Integer) If Me.Parent!Id = 9999999 Then If Me!alt_id < 9 Then Cancel = True MsgBox "Alt ID needs to be greater than 9" End If End If End Sub But still...

Well I didn't get any errors however nothing else happened either. When id was 999999 I was able to leave alt_id null, -1, 1 or 9 without any messages. I added what you gave me on the before update of sub_form.alt_id. Nothing. If I wanted to adjust the criteria to be if id = 999999 then...

Alt_id is the field name however it is not in the main foarm form it is in the sub form. If the sub form.id = 999999 then the sub form.alt_id should be greater then 1. All I want is if the id is 999999 then the data entry professional has to put in what the alt_id is. They get info from...

I did as asked but i get an error that Me.Parent!alt_id cannot be found.

In a subform If the my main.id field is 999999 then the main.alt_id field needs to be greater then 1. I thought i could set the validation rule to be iif(main.id='999999', '', main.alt_id>1) but that didn't do anything. Any thoughts or ideas?

Well I added the subform and linked it up but uncertain on how that worked. In anycase thanks for your solution.

I guess I need to do some research then becasue now I'm uncertain how to get my subforms to link to this. Was I able to do this in Access 2003. It's been a long time but I thought I do this before.

It is for searching purposes. the control source is main.id.

I created a form and in the form I placed a combo box. I set the row source to a query built of a single table. Bound Column =1. Column Count=5. Column Widths = 0",1", 1", 1", 1". List Wdth=4". Column main.id, main.search, main.c_name, main_add1, main_state. In Form view I select the record I'm...

Thanks for your help vbaInet.