VBA Sub Form Move to Last Blank Field

[TinaCa]

I have a subform showing invoices that need to be paid in descending order by date. (6/1/12, 5/1/12, 4/1/12, etc. I originally set it so the cursor left the main form and went to the Check No Field in the subform. Problem is it goes to the first row. I needed it to go the record 2 or 3 down that needs to be paid (FIFO). i.e. It's 6/1 and I have a payment for 4/1/12 to enter. I want the subform to go that empty check no field - so not last and not first. So......Go To Last CheckNo field that is empty.



Any ideas?

[June7]

Is the subform filtered to show only records where CheckNo is null? If so, try:

DoCmd.GoToRecord , , acLast

http://msdn.microsoft.com/en-us/libr...ffice.12).aspx

I am not sure what event to put the code in.

[TinaCa]

This isn't working. The docmd.GoToControl was working when there were recordes in the subform but now that there is no data I get an error message... "You Can't go to the specified record".

Tina

[June7]

Okay, need some code to first check if there is data and only move if data exists. Something like:

If Me.subformControlName.Form.RecordsetClone.RecordCo unt > 0 Then DoCmd.GoToRecord , , acLast

In what event did you put the code?