Search results

Hi Bob, I greatly appreciate you getting back to me quickly. I tried the code. It still does the same thing of not always retrieving the correct record. Thanks again. GMSRE

Hello I am working in Access 2007. I have a dropdown list that shows the recorded number(RecordIDNo), community ID number (CommunityID) and community name (CommunityName )for the list of records associated with the community ID number. I want retrieve the record I click on in the dropdown...

Hi Paul, It works. This is just what I was looking for. Thanks so much. GMSRE

Hi Paul, The communityID field is in text format. The RecordIDNo field is in number format. This is the code I am using. Thanks again for your help. Private Sub Form_BeforeInsert(Cancel As Integer) On Error Resume Next Dim rs As DAO.Recordset Dim strSQL As String Dim lngID As...

Hi Paul, The NZ(… code was very helpful to get the record id number in the RecordIDNo field to populate and increment. The remaining challenge is to get it to keep track of the number of records for each individual community ID. For example if I inputted 3 records associated with community ID...

I pasted Nz(DMax("RecordIDNo", "DataForm", CommunityID = '" & Forms!DataForm!Community & "'"), 0) + 1 and it turned red. Where would Nz(DMax("RecordIDNo", "DataForm", CommunityID = '" & Forms!DataForm!Community & "'"), 0) + 1 be used? Thanks.

Hello, Access 2007 In my input table I have a field called RecordIDNo. I have another field called communityID. I am trying to generate a number in the RecordIDNo field in relation to the communityID. For example there are communityID 0001 and communityID 0002 I want the database to keep track...

Hi Bob, I do have an input table that I created. I opened a blank form added the combo and list boxes one at a time. How can I tie in the table I created? What code would be good to use to get what I am looking for? Thank you for getting back to me quickly and your help. GMSRE

Hello, I am working in Access 2007. I was able to create County combo box County that limits its list based on the selection made in State combo box. I was also able to create a County ID list box that limits its list based on the selection made in County combo box. For example the State combo...