Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / May 2008

Tip: Looking for answers? Try searching our database.

Problem with subform control's default value

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Zip00021 - 30 May 2008 14:53 GMT
I am having problems with a control in one of my subforms.  

In this subform, I've set the value of a combo box to default to the value
of a control on the main form.  

When I view or first click into the new record line in the subform, the
default value appears to be working fine.  However, when I start entering
data in the next control in this new record, the combo box value changes.  It
seems to be defaulting to the name of the form itself.

I do have another form/subform which I set up the same way, and it seems to
be working fine.  The only difference I can think of is that the one which is
working is based on two tables - not a table and a query.  Maybe I have the
relationships set up incorrectly?

Any help would be greatly appreciated!  Thank you!!
Klatuu - 30 May 2008 19:17 GMT
Post what you have coded in the Default Value property of the Combo.
Is there any other code in your form or subform the references this combo?
Signature

Dave Hargis, Microsoft Access MVP

> I am having problems with a control in one of my subforms.  
>
[quoted text clipped - 12 lines]
>
> Any help would be greatly appreciated!  Thank you!!
Zip00021 - 31 May 2008 05:46 GMT
Dave - Actually, I figured it out after doing this post!  I'd been building
onto an existing database that wasn't set up how I thought it was... so had
to go in and change out some of the relationships and other items to make it
all link together correctly.  Thank you for your kind and timely offer of
assistance!!

> Post what you have coded in the Default Value property of the Combo.
> Is there any other code in your form or subform the references this combo?
[quoted text clipped - 15 lines]
> >
> > Any help would be greatly appreciated!  Thank you!!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.