UnMatching data

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!!!
 
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
*
 
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.
 
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
*
 
Back
Top