[AccessD] Basic Form Questions

Jamie,

1.  I presume the form is bound, since what you describe is how bound
forms behave.  If you want it to show blank fields until you select a
record, then you can unbind the form and do the record fetching
yourself.

2.  To get a form to show new data you need to refresh the form or
requery the form's datasource.

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us



-----Original Message-----
From: Jamie Kriegel [mailto:jamie at kriegelpcsolutions.com] 
Sent: Thursday 2003 May 29 21:51
To: accessd at databaseadvisors.com
Subject: [AccessD] Basic Form Questions

Hi there,

I have 2 questions and I was hoping one of you generous and intelligent
people could help me.

1.  In a form I have a combo box that I use to as a lookup.  For
example, my form holds customer information and I use the combo box to
choose a paticular customer.  When I choose this customer, it is his/her
information that I see in the form.  How do I get this combo to default
to a blank? Right now it shows the name of my previous search in the on
screen control which can be confusing.  I want it to remain blank until
I choose a customer from the list.

2.   I have a form with 2 subforms.  The main form is customer
information,
subform 1 is insurance policies that customer holds, and subform 2 is
any dependents that customer may have on a particular policy.  When I
add a new policy for a customer (subform 1), I have to go to a different
record and back before Access will allow me to enter data on subform 2
(dependents on that policy).

Any ideas would be wonderful!  Thank you,

Jamie