Search results

yes, the link master and link child fields are set...

I have a form with a subform, with the proper one to many relationship with their respective tables. Everything looks good in design view and in the properties window... but in form view, the subform doesn't display anything, not even the empty text boxes in the details section (new record). ...

Uh..no but I have another couple of tables that handle food supplies and it is set up like you just mentioned... I don't have any queries set up yet though. Are you saying to create the query first and then create the form from the query?

sorry gemma-the-husky....you posted while I was writing my last post... I see what you mean..my client says the list won't ever change, but I should set it up so that it CAN be changed... I will have to change some tables around, but I think this will be the better way to go, especially when I...

Mr. B.. Thanks! I will see what I can come up with... does anyone else think this may not be normalized, the way I have it set up?

missinglinq... yes I realize that is a lot for a single recordsource... it is a single table. Here is the list Accounting Attorney Auto-Gas Bank Service Cash Over Condiments CC Merchant Fees Dividend Checks Employe Incentives Equipment Equipment Rental Insurance- Wrk Comp Interest Earned...

Gemma-the-husky... thanks for your fast reply! The fields are a listing of monthly expenses that my client keeps track of for his Subway stores. I believe it is normalized correctly. Speed and efficiency are key to my client...tabs I think would bug him to much...can you work the fields downward...

Galaxiomathome... no I want a form view. Will that still work? Gemma-the-husky... yes they need to all be together for optimal data entry.. My text boxes are as narrow as they can be (if that is what you mean). If there is loads of ways to set this up properly and with speed of data entry in...

I have to create a form with 39 fields to fill across...I can only fit 20...any ideas? I'm really stumped..

I found the answers I was looking for in a document someone posted in the code snippets section...called 'Subform Syntax' (not sure how to create a link to another thread) The VBA code I used was.. Me.Parent.Recordset.MoveNext in the last field's AfterUpdate event.

I need to navigate the recordset in the main form from the subform. The main form displays the parent record, and the subform the child record for data to be entered. After data is entered, (in this case only one row) I need to do a .movenext in the main form recordset...preferably on the...

missinglinq: Yes, that is the scenario...and the tabes are set up as you described with a one-to-many relationship between them, and a form and subform is set up and linked accordingly. If possible, on the subform I do not want it to show any previous records, just a new empty record. There are...

Ok...I know that the best way to set up a table is to work across (columns) with the items you need to store a piece of data for, and let the data work downword (rows). But what if each item needed 3 pieces of data? What I have is a list of items, that needs to be updatable, that each month has...

I kinda figured I didn't make much sense... I have 5 txt boxes on a form... EOM, Sequence, Description, Opening lbs, Closing lbs ('EOM' (end of month) is a combobox bound to a lookup table) 'EOM', 'Sequence', and 'Description's values are taken from a recordset I created from a different...

I have 5 fields on a form used for inputing a new record. 3 of them are autofilled with data from a different table than what the form is linked to...and the other 2 are user filled. Only 4 of the fields get INSERT(ed) INTO the table that the form is linked to. At first, the 2 fields the user...

I found it! Thank you gemma-the-husky for the 'cycle' reference, that is what I needed!

Yes that sounds right...do you know how to find it on access 2010?

Yeah...I didn't think about the differences between versions...I have Access 2010. I found that setting but it effects every enter key hit, and not the last field enter..they are different in that every enter hit moves you through the fields in the record, but at the last field you have a choice...

I've been searching all up and down access options...do you know about where it is? Or at least what category? Thanks for your response =]

Ok, a while back I set a setting for the enter key behavior when it hits the last field in a record on a form, to go to the first field in the same record, as apposed to the first field in the next record. Now I need it changed back and for the life of me I can't find where the setting is! Has...