
3rd Post: I am at my Wit's End
Dear All
Ashok, thanks for your help, but I am now at my wit’s end.
Officially I am now not a VB programmer anymore. Please
help me and put me out of my misery.
I am trying to create a VERY BASIC VB database
application, but can’t.
What I want:
I want a Master/Detail form created with a wizard,
selecting ADO Control. OK there. The details on the master
(employee details) and the detail (project details) update
OK. If I update the Master or detail it is saved.
Yipppeeee!
The problem is with the dataCombo. If I move from record
to record the dataCombo shows the correct information, ie
employee name. If I manually change the field that links
the Master and detail together, the dataCombo changes to
reflect the change in field value. However if I select a
value from the dataCombo the linking field does not change
but the underlying datasource does. The change in values
are not reflected through to the form.
To me the dataCombo is working, it is just that the data
is not being refreshed. How do I do this?
If I update the dataCombo I would like all the fields like
Age, BirthDate, etc. to change in line with the change in
linking field or dataCombo, but it does not. It only
reflects the change when I close and open the form, not
even when I move up and down a record
Please, please help. I will gladly send a copy of the form
and sample database to anyone who can help!!!
Alastair MacFarlane