Status: Solved
Priority: Medium
Security: Public
Views: 491
Last Modified: 2013-11-05

Listbox doesn't open to a new (blank) record when form opens for new record input

I have a form that opend for a new record input. On this form is a listbox. But when the form opens the listbox is not empty and should be. What is wrong with my code... ?...

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmProject"
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.GoToRecord , , acNewRec
Forms!frmProject.List136.Requery
Forms!frmProject.txtDrops = ""
Forms!frmProject.txtJobN.SetFocus

Exit_Command12_Click:
Exit Sub

Err_Command12_Click:
MsgBox Err.Description
Resume Exit_Command12_Click

SteveL13

Asked: 2011-03-04

Advertise Here

Microsoft Access

1 Solution

LVL 77

peter57rCommented: 2011-03-04

What is the rowsource of the listbox?

SteveL13Author Commented: 2011-03-04

Is a query... Here is the SQL code:

SELECT Format([tblProjectDetail].[DetailID],"0") AS [Drop], tblProjectDetail.JobN, Format([tblProjectDetail].[Qty],"0") AS Qty, tblProjectDetail.DropDueDate AS [Due Date], tblProjectDetail.Complete, tblProjectDetail.Billed, tblProjectDetail.Name, tblProjectDetail.Cancelled
FROM tblProjectDetail
WHERE (((tblProjectDetail.JobN)=[Forms]![frmProject]![txtJobN]))
ORDER BY tblProjectDetail.Complete DESC , tblProjectDetail.DropDueDate;

LVL 77

peter57rCommented: 2011-03-04

I don't understand why you are not getting an error.

Does txtJobN have a default value?

SteveL13Author Commented: 2011-03-04

No it does not.

LVL 74

Jeffrey CoachmanMIS LiasonCommented: 2011-03-07

Perhaps you should take a step back and explain exactly what this system is supposed to be doing...?

SteveL13Author Commented: 2011-03-10

When I open the form for a new record entry, the lisbox on that form should be empty.

LVL 77

peter57rCommented: 2011-03-10

I suspect there is more to this problem than is apparent here.
But a simple fix should be..

WHERE (((tblProjectDetail.JobN)=nz([Forms]![frmProject]![txtJobN], ""))

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Listbox doesn't open to a new (blank) record when form opens for new record input

Join & Write a Comment Already a member? Login.

Featured Post