Tannim

That is correct.  If there is not a payee... this will not work as written.  It's trying to open a Form to a record that doesn't exist.

I'm not sure which Lesson 5 you're referring to (Beginner, Expert, Developer, TechHelp, etc...)

I think if you keep watching, Rick talks about how to deal with this.

-Raymond

It's the check register seminar. When Rick does it in the video, it works even to add new payees.

I found a workaround. I just made PayeeF continuous and deleted the section of code that made it open to the specific record

Tannim

On your PayeeF Form Properties, go to the Data Tab:
     Make sure "Allow Additions" is set to YES
     Set the "Filter On Load" to No
     Set the "Allow Filters" to Yes

On your PayeeCbm:
     Make sure you have the PayeeID set as the Bound Column.

Which version of Access are you using?

-Raymond

It's whatever the newest version of 365 is. 2019, I think.

I checked and all as you say.

Tannim

That's strange... Mine is 2007-2016 and it works for mine.

Do you want to post some pics of your tables, forms, combo box properties?

-Raymond

IDK what happened but now it works. Access is trying its level best to make me look foolish this week.

Check to make sure there  is a value in the Combo Box otherwise you will get an error.

If Not IsNull(PayeeCmb) Then
    DoCmd.OpenForm "PayeeF", , , "PayeeID=" & PayeeCmb
End If

Kevin

I rewatched Rick's Check Seminar Lesson 5... and when he double clicks a record with no ID... it just opens to a new record.

Rick's does not have the "If Not IsNull".... and it works in mine without it.  I'm wondering if it's a Version difference...???

-Raymond

Raymond Probably a Default Value of 0 in the Table.