Same ID field

[tarcona]

If you open up my example database and open Add/Edit Records and you go down to Disposition and you select Won, Sales Won form pops up. As you can see, this form has a Lead ID field. I want this Lead ID field value to be the same as the Lead ID field value on the Add/Edit Records form. So for the first record the Lead ID is 5574. But the Lead ID in the Sales Won form comes up as 1. I want it to be 5574. How can I do that?

 

[khawar]

Your attachment doesnot include the form you mentioned

 

[tarcona]

I appologize. Sorry, its a Monday. Ha. Here is the new database with the right forms:

 

[motleyjew]

Try this out. I took out the autonumber and made the default value of the lead ID whatever is being shown in the Lead Information form.

 

[tarcona]

No that doesnt work. Because when you are in the Add/Edit form and go to another record so the Lead ID is different, the Lead ID in the SalesWon form does not change.

 

[motleyjew]

Sorry about that. I forgot to add the dame code in the criteria in the record source. Try this one.

 

[tarcona]

Works perfectly THANKS motleyjew!

 

[motleyjew]

No problem. Good luck.