Hi again - Sorry to come back with another question about this, but now that I'm adding records to the database I see something wrong with my coding.
I'm using this:
Private Sub Form_DblClick(Cancel As Integer)
Dim strWhere As String
Dim stDocName As String
stDocName =...
Thanks, that worked! I have the form PROFILE set to open to a new record when someone wants to add to it...that seemed to be overriding acFormEdit so it opens to a specific record with WHERE but then clears. Do you know if there's a way to stop this in DoCmd.OpenForm stDocName, , , strWhere...
The results are based on a query that contains but doesn't show STAFF_ID, so I thought maybe the record could still link to STAFF_ID without actually displaying it and the user could double click the record selector when it's highlighting that record. Maybe this is just not how it can work.
So...
Ok, so is lboComplaint my subform and cmdCmpID my primary key? (Im my case, subSEARCH and STAFF_IF)...is the where condition this then:
Else
stLinkCriteria = "[STAFF_ID]=" & Me![LNAME]
DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormEdit, acDialog...
Hi Duane -
Thanks for your response.
I can provide field names in addition to the form names I mentioned:
-the main form here is SEARCH_FORM and it includes different criteria.
-the subform is subSEARCH (bound to qrySEARCH) and it includes the text fields (in order): LNAME, FNAME, POSITION...
Hi -
I'm using Access 2003.
I have a main form SEARCH_FORM with criteria that filters qrySEARCH and displays the records in subSEARCH.
I want the user to be able to click on one of the search result rows (which displays only a few of the record's attributes) and have the full record open on...
Hi - thanks for your response.
I've read through this (as well as other) info re: data structure but I think the problem I'm having is for each row (staff member) I have multiple columns (1-5 portfolio items, 1-5 expertise with several attributes each).
I think these portfolio and expertise...
Hi -
I'm building a database in Access 2003 that will serve as an "expertise directory" for staff. I have 3 tables with 3 corresponding forms, each set up as follows:
1) contact information (staff_info)
2) current work projects - (portfolio) up to 5 different items, with the titles entered by...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.