I have form with 2 subforms (subform1 and subform2)
subform2 depends on data on subform1 ... it's something like records
(subform1) and comments (subform2). So, I must pass record_id from
subform1 to subform2.

I have the following field:
Loan_Number
What I want to happen is that the user opens up the form.  They type in
their loan number, lets say it's 12345.  They click on a pair of binoculars

Just recently, when I edit the vb code due to an error stoppage it doesn't
seem to update it after I close.  I then have to go and close the forms then
open up the vb editor for it to take.
For instance, if there is an run-time error I'll hit debug and make my

I have a bound combo box on my form.  I would like to change it so it shows
both columns of the table it gets the list from, but I only want to store the
first column as the data.  Can this be sorted too?
Thanks!

Is there way to convert current dates to julian dates in
access forms and queries? If it can please explain.
Floyd

How do I increase the number of records in the subform datasheet view as I
save each record from the main form. I have autonumber set up to generate a
new number for each record as it is added to the table supporting the subform.
All records appear on separate lines in the table ...

The mouse wheel (inbetween two buttons) on the mouse, when "wheeled" up and
down browse between records in a form.  I wish to disallow this function, and
have the wheel do what it does on the web....to go up and down on the page
instead of scroll between records.  What setting is ...

What I'm tring to do seems very simple. I'm tring to make a form from a
query using the form wizard. Before I can get through the wizard, I get an
error message stating "No Current Record". Am I running into a bug? Is it
time to do a reinstall?

I'm going live with my DB tomorrow morning.  I wanted to to Edited Records
for my lock type but ran into a problem, this weekend when I took it to our
office and had it on multiple computers for the first time. (I've been
designing at my house, in my spare time (right), so I ...

Greetings all again,
I'm changing the way a database that I created to keep track of blood
glucose levels works and decided to "prefill" the date field for a complete
year to make entering data for my dad easier (he is quite naive with

I have a small mdb I've written to track exercise and calories consumed.
I have 2 small tables -
Food (All foods I might eat)
ID Autonumber

I'm trying to add a Common Dialog control to a form, so that the user
can select a file.  However, when I attempt to add the control on the
form, I got the following message: 'You don't have the license required
to use this ActiveX control.'.  I need a license?  Do I have any

I have a Customers table where I wish to move via the customers form a
record to another table   tblarchivedcustomers
How can I do this? I wish to do it via an on change event of a combo box.
i.e. status change from active to archived

I have a customers form where I show the active and archived records
By default it shows the active customers. I have a option group on the form
to set the status of either
active or archived and also use a query to set the default of active or

Is it possible to control where a popup form will show up?
TIA