UnMatching data

[Guest]

I created an Unmatch query between tblA and tblB.......now i want to add this
data into tblA using a formA......formB is created with a listBox that has
The unmatching (SomeName) data in them(row source = qrUnmatch), i like to
select and item from this list and open formA, with the item populated. formA
has a row source = tblA, AND formB/listbox has a row source = qrUnmatch. can
this be done, if so...HELP!!!

 

[strive4peace]

Hi will,

In your Unmatch query, add another field:

field --> FoundMatch: IIF(Isnull(tblB.primarykeyfieldname), false, true)


position the checkbox at the beginning of the row

on the Click event of the checkbox, if it is not checked, then add a
record using SQL to append a record

if it is checked, delete the record using SQL

then, in each case, refresh the form


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[Guest]

The code that you provided me with does not create a check box, it creates
result of -1. how can i append the unmatch data into the table and at the
same time flag each item as new on that form? i am trying to rephrase my
question, might give you a different way of looking at it. thanks again.

 

[strive4peace]

Hi Will,

it gives the data that the checkbox needs..

turn on the fieldlist

click on the checkbox tool

drag the FoundMatch field to the form where you want it

~~~~
"might give you a different way of looking at it"

I understand what you need -- I think you are missing something here --
your query uses a LEFT JOIN. You wil not be able to add records on the
form with this recordset -- one way to do this would be to use SQL to
append records/delete records when you click the checkbox.


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*