Date: Tue, 09 Nov 2004 01:00:39 GMT
Message-ID: <XEUjd.10214$up1.9696_at_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 Tue Nov 09 2004 - 02:00:39 CET