Gurus,
I would greately appreciate some input with the following.  I appologize for
the long mail.
What I need to do is when I enter the data in the form and before I go to

I have a form in an Access 2000 data base which has a "custom toolbar"
associated with it. The toolbar is set using the form properties menu. When
the form opens, the custom tool bar displays just fine. When I click on the
print preview to print the form the default "print ...

Is it at all possible to have (on the SAME form) one combo box which, when a
member is chosen from the drop-down list, three patient ID-related text box
fields are filled in via a lookup to a table, and ALSO have another combo box
which behaves the same way, but the resulting ...

I am debugging some code that someone else wrote and have run into what I
think is a scoping problem.  The original writer of the code has a combo box
on a form.  Using the properties sheet, he defined:
   Row Source Type = Table/Query

I have a table named - "EmpVacation" , the fields are EmpName, VacFrom,
VacTo, VacRemarks. When any employee go on vacation, I update this table.
There is a Form for posting daily attendance named "EmpAtdnF", which is
based on another table "EmpAtdnT". Every day I post data for ...

Is there some way to assign topvalues to a query with code.  Help screens say
can't do directly, but is there some way indirectly?

I am using Access 97 and I want to open a form, insert parameters and then
run a public subroutine on the form to perform a search.
I can do all this except run the routine.
The code is behind a button on the search form:

Upfront disclaimer: I'm an Access newbie, though experienced in other
programming environments/languages.
I'm trying to fix a database for a friend, over the weekend, so any quick
answers would be hugely appreciated.

Using a [cboPosition] to limit selections in [cboApplicant]
[cboPosition] Rowsource is:
SELECT TlkpAppPosition.PosID, TlkpAppPosition.PosDesc
FROM TlkpAppPosition;

I am running Access 2K on a W2K OS.
I should know this but I am missing something.
I have form1 with a combo box(combo0) for Name and a command button
(Command2) which opens a second form2 based upon the name selected in

I have 2 labels that are supposed to change the query in a subform.  I would
like lblAllDates to show all record (no filter on), and then lblFilterDates
to show all records after the current date.  Can someone let me know what I
am doing

I am designing an ms access application that many users will be using.  Due
to the number of people, I would rather not use the distributed front end
application re: changes and re-distribution..yadda yadda yadda.  
Can forms be opened and used simutaneously by users using data ...

I need to pass my database to a help forum in order to get some assistance.  
I want to scramble up some of my data for privacy purposes.
Does anyone have an existing routine or suggestion on how to do this?
I'm ideally looking for some procedure I can pass a field value to and

I have an filter form with numerous options...
and I pass it to the form filter with a strwhere where condition, that
filters the form.
Now, the records ARE filtered on the form..

My SQL Statement is not Updating and I can't figure out why...any help
is appreciated.
Thanks
DS