Search results for query: *

thx dhookom... I think I need to change my title from programmer to "not so sure what I'm doing anymore"... LOL I forgot how sensitive access is to having a space in the field names. I am still having trouble getting the two subforms to even come up as a "add" form to add data in each subform...

thx... I forgot how sensitive Access fields are to using a space in the field name. the little things that make you go ... ugh!!

It is not opening to the specific record... it is opening the correct form. DoCmd.OpenForm stDocName, acNormal, "Tenant Name= '" & Me.Search_Location & "', acFormEdit, acWindowNormal

That's linking them... I was looking on populating fields from the main form to the subform on data entry.

I got it to open the form but not to the specific records :-/

I need help! I have a form that will be used to add new customers... it has two subforms on it... how or what do I do to get the data from the main form field to populate the subforms in the proper fields?

I want this to open the form for the selection on in the combo box... I have not programmed in Access for many years :( Dim stDocName As String stLinkCriteria = Me.Search_Location stDocName = "frmLocationLookup" DoCmd.OpenForm stDocName, acNormal = "[Tenant Name]=" & "'" & [Tenant Name] &...