Inout into a field

I am having problems inputting into the blank fields..help.  The detail portion is based off a query.
Line-Item.docx
Jass SainiAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
This seems to be related to your previous question on continuous forms...
You still have not replied to my question here:
http://www.experts-exchange.com/Database/MS_Access/Q_28574499.html#a40481398

It is not clear from just a screenshot, what exactly you have there, how it was created, what your ultimate need is?

"having problems inputting into the blank fields"
?

JeffCoachman
JeffCoachman
0
Jass SainiAuthor Commented:
Hello Jeffrey,

Sorry about the confusion as I said i had another meeting with the boss.  

      A      B      Total Initial Allotment      C      D      F      E      Total BC#1      G      H      I      Total BC#2
Line items      1      1      2      1      1      1      1      6                        
Line items      1      1      2      1      1      1      1      6                        
Line items      1      1      2      1      1      1      1      6                        
Line items      1      1      2      1      1      1      1      6                        
Line items      1      1      2      1      1      1      1      6                        
Line items      1      1      2      1      1      1      1      6                        
Total                                                                        


I have the Line Items in a row and Alpha are the Column headers and the numbers are the inputs.    I am trying to put a number in the blank field as I am part of a budgetting unit.  I have to list out the line Item per Budget.  They have a beginning budget.  The analyst adds or subtracts from the budget.  All this tied back to a table that collects all the data.  

Do you still need more info..please let me know.  I queried the records by Analyst and thier programs.  Thus making a a form.  In the form is where they input the data.  i just cant get anything to input into the blank field ..if I bind it to a field.
0
Jeffrey CoachmanMIS LiasonCommented:
If this  "Form" is based on a query, then updating this may not be possible....
You may have to add the values to the source table first.

But again, ...it is still not clear how this form is designed...

Can you post a simplified sample of this database?
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

Jass SainiAuthor Commented:
It's the Final_frm...Thank you for your help
Allotments-DB-QWorks-NewFund-08.zip
0
Jeffrey CoachmanMIS LiasonCommented:
So I open up Final_frm, ...then what?
0
Jass SainiAuthor Commented:
If I use the unbound box it place the same value in all the boxes...would like it to do with only one record at a time.  

The sunken in box BC1 Change will not allow me to enter in anything at all.  Thanks for your help.  Please delete my DB after you are done viewing.
0
Jeffrey CoachmanMIS LiasonCommented:
If I use the unbound box
What textbox specifically are you referring to here?
0
Helen FeddemaCommented:
On continuous forms, unbound fields do have the same value for all rows.  That is just the way they work.  You may have to use another form type if this is unacceptable.  I can't tell what the problem is with the BC1 Change control, since I can't see the SQL data source.
0
Jass SainiAuthor Commented:
Helen so there is no way around using a continuous form and having unbound fields that don't have the same value in all the rows.  My boss wants it to be a continuous form as you can see all the items that you are working with and be able to do user inputs.
0
Jeffrey CoachmanMIS LiasonCommented:
JAss SAini,

To be honest here, ...you never explained what you are trying  enter in to this unbound box.
You never stated exactly what you wanted to happen after you did.
Perhaps there is a better way to do this.

As Helen stated, ...this is the way a continuous form works with unbound controls.
...so if your boss is forcing you to use this design, it will never work...

JeffCoachman
0
Helen FeddemaCommented:
Maybe you can get your boss to accept a datasheet subform instead.

Or perhaps pop up an InputBox from the AfterUpdate or DblClick event of a control.

Or an unbound combobox box set so that nothing shows after a selection is made.

But (as Jeff said) we need more information on exactly what you are trying to do in order to give more specific advice.
0
Jass SainiAuthor Commented:
Hello Jeffrey,

i work for the budgets dept.  So every institution gets money...I am starting out with a Initial Allotment of money and subtracting or adding to each prog.  I want to capture all the subtracting and adding to the allotament in the Final table.

Helen, wont the datasheet just show just the one record as well.  I think I tried datasheet and it did just show me just the one record and that's why she wanted a continuous form.  Lunchtime...
0
Jeffrey CoachmanMIS LiasonCommented:
i work for the budgets dept.  So every institution gets money...I am starting out with a Initial Allotment of money and subtracting or adding to each prog.  I want to capture all the subtracting and adding to the allotament in the Final table.

Then why not use a "Bound" control...?
Add a field to the table called "Amt"
Then add this field to the form...
0
Jass SainiAuthor Commented:
So that's what the BC1_Change is that field.  Also that is in my table too, but it won't allow to input anything into that field.  

I am sorry if I am going back and forth on this the unbound field was trail and error.  Of course I want it bound to a field within my table.  That's how I started but I was not able to input anything into it and I did not know why....thus I was trying with unbound field too.
0
Jeffrey CoachmanMIS LiasonCommented:
When you try to edit that field, it says the form is "Read Only"
But I cannot decipher where this is being set (all of the the edit properties of the form are set to "Yes")

On a side note:  Did you create this database...?
There is code here that is fairly complex.
You may have to confide in the person who created this to figure out whey is happening...

If an expert here posted a solution, ...that solution might cause other unforeseen issues in your database (prompting you to post even more questions...)

JeffCoachman
0
Jass SainiAuthor Commented:
Hello Jeffrey,

No I did not create this database.  I am glad that I am not the only one that thinks this is complex.  What did you mean by the last statement.  I am at a stand still ..as I need to figure out how to input into that field.  I am going a different route...maybe just create one table.  Don't really want to do that either.  I have spent four months on this already.
0
Jeffrey CoachmanMIS LiasonCommented:
What I meant was that without a full understanding of your database, ...it is hard for any expert hee to make any meaningful suggestions.

Perhaps another Expert will be willing to dig deeper...

I still feel that you should "try" adding this new field to the source table, ...then add it to the form, ...then see how that works...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Helen FeddemaCommented:
A datasheet should show you as many records as there are in the record source, possibly with vertical scrolling if there are many records.
0
Jass SainiAuthor Commented:
Thank you both of you for helping...I am getting a better handle on what I need to try with your help.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.