Recent content by brastedhouse

Hello again, it seems to be question week. I have a field of member names that is stored in a multivalue field. ugh. When the field is displayed with more than one member, it lists them horizontally across the text box. Not very readable. Thanks MS. So I was wondering if anyone has seen a...

Hurray! Light finally dawned on old marblehead. Thank you very much for all your help. Best, Scott

First, thank you for your patience. The good news is the After Update code is now working. Yeah! The bad news is that the Form Unload code is not. Here are the two ways I have tried to do it: Forms!frmCallsOnly.Form!otherCallTypeID.Requery otherCallTypeID is primary key for...

Hi again, I think I'm surrounding it. It now stops at: If Not .NoMatch Then 'get the last id from tblCallsOtherTypeLU id = DMax("otherCallTypeID", "tblCallsOtherTypeLU") 'set child recordset HERE . . . Set rsChild =...

Hi, sorry this took so long to get back to, but real life intruded. So, I have used your code example to requery the data. The new record is added, but i get an error when i close the form. The error happens here: Set rsParent = Forms!frmCallsOnly.Form.RecordsetClone With rsParent HERE...

first, thanks for the quick reply. second, while i understand what you are referrring to, i do not know how to do that. can you give a quick example? thanks, Scott

good morning, i am trying to requery a combox based on a multi-value field for a not-in-list situation. i usually add to the list as: Dim intAnswer As Integer Dim strSQL As String intAnswer = MsgBox("The location " & Chr(34) & NewData & _ Chr(34) & " is not...

I am a self-taught Access developer. I have gathered a lot of knowledge over the years, but I often need direction, especially on VBA. Thanks in advance.