Add a bound textbox to existing subform

Lol999

Registered User.
Local time
Today, 02:42
Joined
May 28, 2017
Messages
184
Hi, probably a simple one but I can't find the answer and my brain is very tired so here goes:

I have a form with two subforms, I created it through the form wizard, and all is groovy.
However, I have added a data field to the table that is the data source for one of the subforms. I now wish to add a bound textbox to the subform, but the field is not available in the Control Source.
Can anyone tell me how to enable this please?

many thanks, Lol
 
Change the subform record source to a query which includes the field you want to add.
 
You need to open the subform's properties and change the data source, usually a query, to include the field.
 
Its usually me who posts just after someone else ...
Its a pity you can't see new posts whilst you are typing!
 
Well I tried it and it caused so much carnage I had to import forms from a backup to replace the ones I was trying to "improve".
 
Lol999,

Can you describe to us in plain, simple English the requirements of this application?
You are asking readers questions specific to Access form/subform implementation and addition of text boxes. But we don't know the requirement (in business terms) and whether or not subforms etc is a viable option ---could be the best option. There may be other design constructs but we need business context to offer advice/options....

What exactly is the issue with the current set up that you want to improve?

Good luck.
 
Well I tried it and it caused so much carnage I had to import forms from a backup to replace the ones I was trying to "improve".

I fail to see how changing a record source from a table to a query could cause 'carnage'. Even if you messed up the query that should have been fixable by redoing it. And if it was necessary to resort to importing from a backup then only that subform should have been affected!

Perhaps you should define what carnage means for your db!

The post by jdraw is definitely worth following up as well.
 
Okay,the company has a fleet of vehicles which are allotted to a tradesman pretty much for as long as they work for the company or until the vehicle is replaced.
They also issue fuel cards to drivers and obviously need to keep a list of drivers in the company including who is legally allowed to tow a trailer.
These items were kept in a series of spreadsheets, so I was tasked to put them into a database and from that create reports and alerts as to when, for example, the road tax is due on vehicles, or the MOT is due.

I have attached a picture of the form I am working with, it is for vehicle details, it has a subform which displays all the work carried out on the vehicle along with another subform displaying the current keeper and when they were allocated the vehicle.
I created the form after deciding to add a field to the Vehicle Issue table which records when the vehicle was handed back and wanted to add this to the subform.
The Recordsource for the main form is Tbl_Vehicle, the Sourceobject for the subform displaying work carried out is Frm_Maintain subform, and the Sourceobject for the subform displaying the allocated driver is Frm_Vehicle_Issue subform1.
On the subforms I cannot find anywhere to add, alter or amend the data.
I tried making an sql query and everything went pear shaped and I've spent an unhappy hour or two rescuing stuff from a back up.
Hope this is clear as to what I am trying to achieve.
Regards, Lol
 

Attachments

  • Vehicle Details Form.jpg
    Vehicle Details Form.jpg
    87.3 KB · Views: 121
  • Relationships5.jpg
    Relationships5.jpg
    59.5 KB · Views: 98
I fail to see how changing a record source from a table to a query could cause 'carnage'. Even if you messed up the query that should have been fixable by redoing it. And if it was necessary to resort to importing from a backup then only that subform should have been affected!

Perhaps you should define what carnage means for your db!

The post by jdraw is definitely worth following up as well.
Ridders all I know is the whole form just didn't work! I'm frustrated as hell because believe it or not, or perhaps you do,I am a product of the English educational system of IT at higher levels! I have an HNC in Business IT and an HND in Applied Computing. On the course we were taught the most basic levels of Access, no thorough grounding, just enough to get stuff to work and pass our assignments,hence my understanding can be patchy to say the least!
Hence I have NEVER worked in IT!
Cheers, Lol
 
Lol999,

You are not the first person to be frustrated with a database/software/hardware/network or whatever AND you certainly won't be the last. We have all been there.
You are where you are currently, and people here will offer suggestions/advice/direction.

I don't think the issue is the education system or degrees/certifications. Most of the db analysts I have worked with have various backgrounds/interests. Strangely many were left handed?? Some of those have one or more of various skills -- including analysis, communications, details oriented, graphical...
Some were divinity students/lay minister, others were second career shoe salesman, pharmacy worker, child care specialist... so background and interest is a factor but not the whole deal.
 
Interestingly I was pursuing a position in the church and as a chaplain :D
I'm right handed though :)

Hope my previous lengthy post makes some sense.
 
Jdraw

Agree with every word and I'm left handed too....
 
Off track slightly, my father, born early 1920's was left handed, beaten with a stick to use his right hand, and known as a "sinisterist" for his left handed tendencies!
 
Yes in one of my teams of 12, 8 were left handed.
I can also say from some experience, and the point I think may apply to Lol999, is that here are some teachers/educators that have a knack for teaching; getting the concepts across; leading/directing and getting the "student/learner" to appreciate the concepts and try/experience the learning process. And there are others who'd rather be fishing or drinking or anywhere else doing anything else.

There are many people of all different backgrounds who feel the M$oft products are all similar. For example, I've heard this so many times -Access is just a big brother of Excel---Wrong! They are different products, based on different object models and serve different audiences/situations. Similarly there are many competing DBMS product so Acces is not better than Oracle and Oracle is not better than SqlServer --- it is dependent on several factors as to which is applicable/affordable/available....

Anyway back to the intent of this thread. You start with a business issue/problem or opportunity. You get it clearly identified /documented. Get feedback to ensure the issue is clear and complete. You look at some options. Identify what is feasible? What resources/skills are needed? Create some mockups/prototypes get continuous feedback, update requirements etc. Get others involved so it becomes "our solution", not "the programmer built this"!!!
See my post on stump the model for more info.

Bottom line is you have to understand the problem/opportunity and you have to do the analysis. You can't jump into physical Access without some form of clear requirements. Models, prototypes, communication sessions, and especially those where you plant a misconception/error and let the others/users point out the "flaw" you made.

Helps get people onside. So much for the soap box.

Oh yes, I do most things left handed, but write right handed.

Just saw Lol999's last post when I posted. I have 4 grand kids --- 2 are left handed.
 
To be honest the company doesn't know what it wants or needs really, so I'm working on the premise "This is what I think you need based on what I can ascertain from what you have and our chats" which I caveat with "once you've got it tell me what else you need and I'll make it work".
It's a very informal platform, the company is growing massively and in essence I am being trusted to provide what they need, as above.
It's all cool, I don't mind working under these conditions because the owner is a friend, and anything I deliver is way better than anything they already have and will be of benefit.

Still can't get that textbox sorted though :banghead:
 

Users who are viewing this thread

Back
Top Bottom