Search results

When I press the cmd button and execute the following: Dim stDocName As String Dim stLinkCriteria As String Dim intNum As String DoCmd.RunCommand acCmdSaveRecord DoCmd.OpenQuery "InsertNewSBDProspects", acViewNormal, acAdd stDocName = "frmSBDProspects" intNum =...

Rich, I could not get that to work. So I now am running a query to append the new record to the table: Dim stDocName As String Dim stLinkCriteria As String Dim intNum As Integer 'Save the current record DoCmd.RunCommand acCmdSaveRecord 'Run a query to add the new...

The lines below is where I am having problems. I am on the form called 'frmNewCaseTrack' I have entered the 'Case Name' and generated the 'Case Track Nbr' now I need to go the the form 'frmSBDProspect' I want to build a record on the tblProspects using the Case Track Nbr and the Case Name I...

Thank you, everything worked great. Thank you again.

Thanks, Both of you were a big help. it worked. now just one little question in the combo box I want to show only the Sales Rep. right now it shows both the sales rep and the sales office. Is there a way to do that.:D

Yes, there is more than one sales rep at a store...but only one can be entered on the form from the combo box.

This I am sure has been covered but either I have not found it or don't understand what I found. I have a combo box with the Sales Rep name in it. when the sales rep is selected I need to fill a txt box with the correct Office Name. the sales rep name is built from a table that has three fields...

Once I save the record how do I know that I will get that record when I open the form?:confused:

I have a tbl that has 2 fields on it Ctl nbr(autonum) and Ctl Name(txt) when the user enters a new Ctl Name the tbl creates a new Ctl Nbr. then the user press a cmd button to go to the next form. I have to open a blank form except for the Ctl nbr and the Ctl Name which is from the first form...