Re: Passing data

What you want is very possible, but not easy to explain. Here is a partial
sample of some code I used to do a similar task

dim sqlUpdate

sqlUpdate = "UPDATE your_table_name SET [your_field_name] =
value_you_want_set WHERE ID = "
sqlUpdate = sqlUpdate & lblid.innerText 'here lblid.innertext gets me the
id string to match to database
msodsc.connection.Execute(sqlUpdate)

The above code should be added to the onclick event of your checkbox. What
you should focus on is you are going to use an update query to change the
data.

Hmm, on further thought I currently don't have any DAPs that use checkboxes,
but I would assume you should be able to make it a linked field if the
signin.seen field is set to boolean. Then you wouldn't need an update query
unless the table you are trying to update is different than your uniquetable
on your DAP. Keep in mind that DAPs are static once you retrieve the data,
so any changes made while the DAP is open will require you to refresh the
screen to see the changes.

I hope this clears up your fog :)


"rae" <rae@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ECC13B91-E85D-4423-8D9E-99E1A8D1A5E3@xxxxxxxxxxxxxxxx
: Hello all,
: A newbie, I am unsure of how to pass data from an HTML file built from
: within access based on a query...to a table.
: The database is for appointments. After someone enters that they need to
be
: seen, ect...their info populates a table (signin) The secretary has a
webpage
: up (modify)which is populated by a query that only puts up names of people
: who have not been seen. What I want to do is be able to add a check box
that
: populates the table (signin.seen) and changes that fields value.
:
: Clear as fog?
: I am so very new to this, detailed help is very appreciated.
: Thanks
: Rae


.