Add record not showing in listbox first time form is used after form load

Robert Vivian

Guest

Posts: n/a

1st Aug 2003

A table is in one mdb and the code in another mdb. I add a new record using
a recordset object, do the update, close the recordset and database, then
requery the listbox. The listbox is bound to one text field via the just
updated table attached to the mdb with the code. The first added record
after the form is loaded fails to display in the listbox though I can see
that the record was added by looking at the table in the database mdb. The
second add causes both records to display and all adds thereafter work
properly. Anyone have any ideas?

« Great difficulty solving a would be easy problem | HIDE/UNHIDE SUBFORM »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Form based on parameter query only showing one record at a time	transcriptlady	Microsoft Access Forms	1	13th May 2008 10:50 PM
form w/ listbox, select record to show the rest on the form...	=?Utf-8?B?Sm9zZXBoIEhhbmQ=?=	Microsoft Access Forms	7	23rd Aug 2006 07:09 PM
New record added to listbox, but won't load rec in form when selec	=?Utf-8?B?S21oQ29tcHV0ZXI=?=	Microsoft Access Form Coding	4	23rd May 2006 01:04 AM
Open Word Form Letter from A2K Form Showing Current Record	=?Utf-8?B?RGV3ZXk=?=	Microsoft Access VBA Modules	2	3rd Mar 2006 05:00 PM
Label not showing up on gui form called from within load handler of other form	gs_sarge@yahoo.com	Microsoft Dot NET Framework Forms	1	11th Feb 2004 07:01 AM