Compare contents of 2 forms

[chimp8471]

I have a few forms that I use as a shopping cart basket process



Form 1. I have a search form... holds lists of parts. i double click on the part number and it pops up form 2
Form 2. allows the user to choose the qty to be removed then the item is added to the cart form 3.
Form 3. The Basket

When i double click the Part Number in Form 1 and Form 2 opens.... I want it to look to see if the selected part is already in the basket form 3

If it is make a message visible

Can i do this? if so any pointers please

[Micron]

If it's on form3 is it guaranteed to be in a table of cart item? Then when form3 Loads, DLookup on that table & field using criteria like Me.txtpartID=Forms!form3.txtPartID
If DLookup returns a result, Msgbox, else do nothing.

[chimp8471]

Hi,I wanted to get back to you on this sooner but just had yet another bloody knee op!! grr!!

I am sorry for the lack of understanding, Could someone please help me with this Dlookup issues and the if bit to get the message to appear

really appreciate the help

If the item exists in the basket it will be in the table

TtempPartIssued.PartNumber

so on form load (Frm_Cartadd_item)

Private Sub Form_Load()
If =DLookup("Me.txtpartID=TtempPartIssued.PartNumber) ) Then (I am sure this is wrong but i can't work out what to put)
MsgBox "Item already in cart"
Me.LblMessage = Visible
Else
Do nothing (not sure what to put here)
Me.LblMessage = Visible

End If
End Sub

[Micron]

If you don't know how to use DLookup, research it? There is so much info out there yet you haven't made the effort to try creating your own expression. That's the best way to learn. Without knowing your table and applicable field name it's impossible to write one for you anyway.

https://www.techonthenet.com/access/...in/dlookup.php

Hope your recovery goes well. I'm sure that having that done can be a painful and exasperating experience.
Do post back if you get stuck. BTW, please post code within code tags (# on posting toolbar) and use indentation - makes it much easier to read and prevents the forum from doing weird things to your posted code.