Trying to update a recordset based on SQL

my04accord
08-19-2004, 03:43 PM
I am trying to update a recordset that all of my textboxes in a form are bound to as the datamember. The recordset I am having problems with is a SQL view of a Acces table using VB6. The software is a problem ticket type software and I basically have a button the will check for new records and tell the user how many new tickets there were. I have gotten as far as telling the user how many new records there using the requery method but then i can not navigate through them. Thanks in advance, Joe.

Shurik12
08-19-2004, 05:18 PM
Hi,

Well... I'm afraid one can't say what's going on without seeing the code.
One thing is sure: binding in in VB6 is a major pain in the neck. You'll really be better off using ADO and writing everyting in code (see FAQ section for more details if needed)

Regards,
Shurik.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum