I'm trying to go from one subform to a different subform on the same main
page. The only way it will let me set the focus to the next subform is in
exit of the form but I need to do it after I update the last record in the
first subform?

OK I have a continous form displaying reminders at different intervals
for various Companies
The form uses a filter based on a check box called UnderPaymentWF (set to 0)
What I would like to do is that when a user clicks on this check box ie to

Greeting once again
How do you access a specific record in a field in code?
IE record 1 in field last

Is there any way to use the windows system date to create a custom calendar
form so the user can pick up the date (by clicking on it) and transfer it to
the current form?
Thank you!

HI, and Thank you.
I would like to use the same form for data entry and modification.  But
those who do data entry will not be able to do modifications, and the form
will be opened from 2 different places off the menu.  As I look at the form

greetings I am trying to run a pair of sql queries on form load (i know
I should move the second inside the IF statement i just wanna get it
working first) anyways here is the code that I have and it makes it
through the Do loop once but i get a 3265 error on the second loop

I need to clear or reset a form to its initial open blank position when an
error is detected.  I want an action that is equivalent to pressing the
escape key.  Is there a simple code solution for this?
Thanks for you suggestions.  They have always solved a problem.

Hi folks,
I have a problem. I am new to coding in access forms and I have two tables
in two seperate databases of same schema.
Let me name the tables and databases. Let the database be DB1 and DB2, and

I am trying to create a combo box (in my form) to list the queries in my
access database
i am using the row source as

I have a subform "BHUSUBMD" that should remain disabled until an MD
selects their name from a combobox "Seenby".  It seems I should use the
On Dirty event but I don't know how the code should look.
I've tried this:

I have a field that I would like to be disabled unless a value in a
drop down menu is selected.  Is there any way to do this.  I'm sure
there is.  Thanks in advance.

I have a timer event, that updates a clock and a random quote of the
day.  The timer dlay is set to 1000, and the Time Event is as follows:
Private Sub Form_Timer()
Static iCount As Integer

A form shows a number of selected records which I want to update when the
user selects the update % (RPI)
    Me.alrAmount = RoundToNearest(Me.amount * ((RPI / 100) + 1), 0.5, up)
How do I loop through all the records displayed and update the values please

Hi, i've read all the posts on  how to populate textbox with file path,
but just can't get it.
I'm using the api to open a file dialog box, this then generates a
messagebox with the file path. So my question is how do I get this file

I have a field who index property is set to 'yes', disallowing duplicate
records
in table view this works, and duplicate entries are not accepted...
however, in a form view, duplicate records are being accepted, (as long as