I have the following code:
Forms!frm_chooser!cmb_edit_choice.RowSource = "SELECT active, class_id,
class_nm, available_dt FROM dbo_sds_trn_class ORDER BY active, available_dt
desc, class_nm;"

this should be simple (but, obviously, not yet in my vocabulary of code)
I simply want to check if a table [Table1] with fields [Field1,2,3...]
contains a record where [Field1] = Var1, AND [Field2] = Var2...
A simple Y/N responce is all that is required.

In Access 2003, I have a linked bound subform on a Tab. I want to set some
control properties in that subform if the user clicks the tab for that form.
So far, every bit of attempted syntax hasn't worked. Can someone PLEASE tell
me how to do that? (Specifically, I want to set the ...

In a multi-select listbox, how can I detect if the user is clicking on an
already selected row? I need to take some action if the row is being selected
but not if it is being unselected.
Thanks.

Hi everyone! Using A02 on XP.  I've had fits trying to bring data from sub
and subsub forms that are pulling data from various sources for billing
purposes (PartStmts, PartSearch, Amdmts, etc.) up to my bill record.  I have
fields on the sub forms showing summaries of how many ...

I'm looking for a little help. I have a form and I want to update one field
based on another. Basically I want the form to automatically input a number
corresponding with another item. So:
A=1

Can anybody tell me why this code does not work as a Public Function when
using declared variables but will work when explicitly referencing the
actual controls on the form (I would rather use the variables as this
function is called in several sub procedures)?

I have a text box that is linked to a drop down box. It auto fills with what
the person selects from the drop down box. Is there a way to also let someone
add to this text box once it fills in?

Is there any way to scroll a listbox (using VB code) so that a given value is
on the top line?
Thanks.

Is there any way to position to a certain row in a multi-select listbox?
I have my code working for a single-select listbox but it does not work for
a multi-select listbox.
Yes, I could do this by changing the rowsource but I want to retain all rows

I have a form that has a combo box where a user name is selected and added to
a listbox and an assignment table with an assignment ID.   I want to prevent
a user name from being assigned under the same assignment ID more than once.
How can I do this?

I have Access 2000.
My database is a questionaire. The main form is the person taking the
questoinaire. The first subform FrmPersonAnswerSub - a single form linked to
the MainForm- holds the questions.

I have a form that I use to input data into a table. This form has a
dozen fields to fill in ( 2 of them are Combo_Box's). The first and
last fields are required fields. Data Entry is set to "yes" in the
form properties (so that when launched it's at a new record). What I

I have this DLookup and the problem seems to be the last criteria where
GroupLevel = 1 is.
I believe my Syntax is wrong.
Me.TxtGroup = Nz(DLookup("GroupID", "tblInfoGroup", _

I tried to export my report to excel spreadsheets.
I beleive that Access creates a new xls file on the destination.
Is it possible to export an existing spreadsheet and keep the
speadsheet format and multi spreasheets?