473,320 Members | 2,048 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Control Source Issue?

13
I have updated a linked table in the backend to allow me to enter data into a new field (then updated the link in the front end just to be safe). I then went into the front end and updated the query that relates to it (adding the field to the query). Now I am trying to create a checkbox in the subform I am working in in the front end and having no luck. If I enter the data via the query it shows up - both on the subform and in the table, so it's seeing the data. But when I try and create a bound checkbox (yes the name of the fiield is in the little drop down list) it doesn't do anything but check them in everyone's record (in the checkbox) but not in the query or datasheet (as in it is not registering the information). Ideas?
I'm working in Access 03 and don't know too much technical terminology.
Thanks!
Aug 26 '08 #1
6 1726
Delerna
1,134 Expert 1GB
ticking the checkbox while you are in a record results in every record in the form being checked but the records in the table are not being affected suggests to me that the checkbox control is still "unbound".

Please show us the property names and their values of the proerties you have set to bind the control to the query.

Some table/query/field names might also proove helpful.
Also the contents of the "Recordsource" property of the subform.
Aug 26 '08 #2
SoNew
13
okay, I hope this is what you are looking for.

The qry it relates to is called qryList_ReadingCoachPlacements
The field name in the table (called tblReadingCoachPlacements) is blnMentor

The qry involves two tables: tblRadingCoachPlacements and tblElementarySites

The subform I am attempting to put this into is set to look up qryList_ReadingCoachPlacements - and does indeed see all the other data in the tables and query. Just not the blnMentor one.

I clicked on the toolbox, then clicked the field list (blnMentor) and drag/dropped into the subform (according to the access help this creates a bound control) the field list says it is looking at tblReadingCoachPlacements. So maybe I need to actually bind it to the query instead? I'm outta my league here - how would I bind it to something not in the drop down list...expression builder? Help on how to do that would be appreciated if that is what is needed.

The properties show it as:
Name blnMentor
Control Source blnMentor
Enabled Yes
Locked No
Triple State No

The rest is mostly empty.

I know that when I lock it and then open the subform I can't do anything, even though the VBA says to enable controls (so it apparently isn't seeing it as bound).

Help?
Aug 26 '08 #3
missinglinq
3,532 Expert 2GB
Yes, you need to bind the checkbox to the field in the query the subform is bound to, not the underlying table. Delete the current checkbox and exit the form. Now independently open the form that the subform is based on, and from its field list (from the query this form is based on) drag the new field to the form.

Go back and open the main form and your checkbox on the subform should now function properly.

Linq ;0)>
Aug 26 '08 #4
Stewart Ross
2,545 Expert Mod 2GB
Hi Sonew. I hope you are learning more this time than it would appear you did the last (in your previous thread on the same topic, linked here).

You will see that, although answered by different experts, the advice in this thread is identical to that of the last.

It would help us to help you if you did not double-post your questions - if you need to follow up make another post in the original thread!

Thank you

-Stewart
Aug 27 '08 #5
SoNew
13
sorry for double posting - I figured that since I was taking a different route in trying to figure out how to do it I shouldn't tack on to my last posting. I will do differently in the future.

Thanks for your help on this. It worked well to bind to the query. However while it doesn't now stay checked for all the different records, it does for all the records of that one person. That is to say that if they have more than one placement it shows them as a mentor at each placement (oddly not on the presentation of the subform on the main form, but in the dataentry subform itself - if I remove the check for Mentor in a placement where they are not a mentor then it removes it for all the placements...bad.) but if you switch to a different student they aren't showing as a mentor (unless I"ve marked them as such - so that's good).

Thoughts?
Aug 27 '08 #6
SoNew
13
And the place on the displayed subform where it shows up is on the most recent entry, not necessarily the entry that the check box should be linked to. If I checked the box on the 2006 entry, it shows up as 2008 on the displayed subform (not as 2006) - but when opening the dataentry subform it shows on 2006, 2007 and 2008.
AUGH!
Aug 28 '08 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Brett Gerhardi | last post by:
Hi all, I'm having a nightmare with Windows Installer projects and souce control. My situation is that I have a few related windows application / dlls, some generic shared library files and a...
1
by: denasinc | last post by:
Our first real production experience with Source Control came a year ago when we started to cooperate in software development with two other outsourcing companies – one of them is located in...
9
by: Guy | last post by:
I have extended the datetimepicker control to incorporate a ReadOnly property. I have used the new keyword to implement my own version of the value property, so that if readonly == true then it...
1
by: Vladimír Kolesnik | last post by:
Hi, there we need help concerning setting project under source control. We want to have a project on the server, and developers in the local network working on this project. We decided to use...
6
by: Andre Ranieri | last post by:
I'm trying to create a login page for customers to log into our corporate website, our presidents naturally wants the user and password fields to populate from a cookie so the customer doesn't have...
4
by: Robert Schneider | last post by:
I'm using subversion. But I guess this is not important for the issue. So which files of a VB project should be (at least) under source control? Or which ones definitly not? I know from VB6...
14
by: Rolf Welskes | last post by:
Hello, I have an ObjectDataSource which has as business-object a simple array of strings. No problem. I have an own (custom) control to which I give the DataSourceId and in the custom-control...
1
by: rn5a | last post by:
I have created a custom control button which when clicked displays a message in the JavaScript alert dialog. I could successfully compile the VB class file into a DLL & also could add it to the...
5
by: Mark Olbert | last post by:
It appears that FormView controls require the >>exact<< same layout of controls and control types in the various templates in order to function properly. Failure to do so results in a "failure to...
7
by: RichB | last post by:
I am trying to get to grips with the asp.net ajaxcontrol toolkit, and am trying to add a tabbed control to the page. I have no problems within the aspx file, and can dynamically manipulate a...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.