VBA problem.

From: Hal <a_at_b.com>
Date: Tue, 09 Nov 2004 01:00:39 GMT
Message-ID: <XEUjd.10214$up1.9696@text.news.blueyonder.co.uk>

Hi,

Please see http://webmonky.myby.co.uk/problem.JPG

I have 1 Text Box in a form (ms access), one for an Order # .I currently have the form working so when I enter (or scan) an order number, that order number (which is a field in a record) is marked as DESPACTHED in a Tickbox Field under that record.
Here is the code..

CurrentDb.Execute "Update tblDownload Set DESPATCHED = True Where ID = " & Me.txtOrderNumber & ";", dbFailOnError
Me.StatusListBox.AddItem "ORDER # " & Me.txtOrderNumber & " MARKED AS DESPATCHED"
(Thanks Joe!)

...Now what I need is for it to continue doing that, but to ALSO add a Tracking Number (using another text box) to the same record as the Order #.

Any suggestions would be excellent, I've had a shot at it and I just can't get my head around it.

E-mails welcome at bluebelltrading_at_blueyonder.co.uk

Many Thanks,
Nick Received on Mon Nov 08 2004 - 19:00:39 CST