Search results

The way we do it is by having a contact history subform on the contacts form. I was a little unclear what you were doing so sorry if I am repeating what you have already done. tblContacts ContactId - AutoNumber & PrimaryKey and the rest of the fields you want. tblContactHistory...

I sent you an example

I have a main form and a subform on the main form. What I need to be able to do is have a lookup combobox on the main form and choose a value from the subform and find that value in the subform and go to that record. I need to have a combo lookup with values from the subform not the main form...

I am sorry I need to have a combo lookup with values from the subform not the main form.

I have a main form and a subform on the main form. What I need to be able to do is have a lookup combobox on the main form and choose a value and find that value in the subform and go to that record. Thank you

If your still intrested Candice Tripp has a sample database on buttons you might like. She is at candicetripp.com. I tried to get on to her site and had no luck. If you can not download it off of her site I will be glad to email it to you. Good luck

I Emailed you a sample I think you might find helpfull. If it is not I have a couple more that might help you let me know.

Go to Microsoft's website and do a search for this article Q175066. They have a sample database that I think will help you.

Private Sub Form_Open(Cancel As Integer) On Error GoTo Form_Open_Err DoCmd.MoveSize 4320, 1440, 5184, 4896 Form_Open_Exit: Exit Sub Form_Open_Err: MsgBox Error$ Resume Form_Open_Exit End Sub

Take a look here http://www.mvps.org/access/api/api0024.htm

Take a look here http://www.lebans.com/tabcolors.htm

Do a search in this forum on "Animation" and you will find a few answers.