Recent content by johnmcd

Bob, Perfect - that's exactly what I needed. Yes, it's a bound field/form, but I didn't realize that the autonumber was set in the form prior to saving and that I had access to it. Thanx! John

Hi all, I have a VBA module that runs on the 'click' event for a button on a form that's opened in 'Add' mode (a typical 'Add' button). In the module I use the command: DoCmd.RunCommand acCmdSaveRecord to save the record, and that's working just fine. However, in that same VBA module, I...

Got it! All, Thanx to your help I've figured it out. I modified the VB code in the 'Click' function for the Requirements listbox to include the following: =========================================== Dim myConnection As ADODB.Connection Dim myRecordSet As New ADODB.Recordset Dim mySQL As String...

Thanx! Bob & Curtis, Thank you both very much. I'm going to play around with both suggestions and see what I can come up with. I appreciate the quick responses. Have a great New Year! John

Hi all, I'm a newbie with Access (although I do have some experience programming other MS products (like VB)) so I'm not sure I'm even asking this the right way, but here goes: I have a database with 3 tables: tblRequirements contains requirements and has the following fields: Number...