Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by hlnewman
-
Simple lookup form/subform changing subform table records??!
That did the trick! Should have figured that out for myself, duh. Was too brain-fried last night and not paying attention. Thank you so much; the fix is working flawlessly, and I'm replicating it for other searches throughout the database. So much for the hours spent tearing my hair out with...- hlnewman
- Post #13
- Forum: Microsoft: Access Forms
-
Simple lookup form/subform changing subform table records??!
In my own code, I had the whole item on one line (just had split it for ease of viewing here): Me.RecordsetClone.FindFirst "[ManagerName] = " & Me![Combo4] <----------- all on one line The specific error I'm getting is "Runtime Error 3077: Syntax error (comma) in...- hlnewman
- Post #11
- Forum: Microsoft: Access Forms
-
Simple lookup form/subform changing subform table records??!
Okay, I'm getting closer. But I get syntax errors on the After Update code for my scintillatingly named Combo4 combo box. Mine looks like this: Private Sub Combo4_AfterUpdate() Me.RecordsetClone.FindFirst_ "[ManagerName] = " & Me![Combo4] Me.Bookmark =...- hlnewman
- Post #9
- Forum: Microsoft: Access Forms
-
Simple lookup form/subform changing subform table records??!
Thanks! I'll give this a shot tonight. H- hlnewman
- Post #8
- Forum: Microsoft: Access Forms
-
Simple lookup form/subform changing subform table records??!
I'm finally starting to get it. :-) Two more questions: 1. Using this method, what will happen when managers who don't have any payments in Table2 attempt to search for their names? Because they won't have an entry in Table2, there won't be a first record to move to, so will I have the same...- hlnewman
- Post #6
- Forum: Microsoft: Access Forms
-
Simple lookup form/subform changing subform table records??!
So how do the two boxes interact with one another? And is the recordset that provides the "answers" still in a separate subform, and if so, what's the relationship between the subform and the text box - because that's what's linked, right? Sorry to be so confused. H- hlnewman
- Post #3
- Forum: Microsoft: Access Forms
-
Simple lookup form/subform changing subform table records??!
Hey all-- I've got an embarrassingly simple project to complete in Access that's making me feel like a real dummy. I hope you can help. I'm trying to use two tables in a form/subform setup to allow users to look up and change records in the subform's table. The parent table is a list of...- hlnewman
- Thread
- Replies: 12
- Forum: Microsoft: Access Forms
-
Allowing user to lock out other users inside session
I've got an Access 2000 database with forms that is routinely open for multiple users to update at once (with the Edited Record being locked). But once a month, one user needs to create a report from all the other users' input, after which she presses a button to archive the data from the...- hlnewman
- Thread
- Replies: 1
- Forum: Microsoft: Access Forms
