Recent content by pelicanbuyer

No its the main form scroll bar that moves I believe. It just moves to focus on the subform when I tap the tab with the subform on it :/

Can you therefore setfocus of a subform to be something on the main form?

Unfortunately not, the tab on the subform is directly under the tab on the main form with nothing in between. I just wondered if there was a command to make the scroll bar go to the top on opening the subform as its the main form scroll bar that moves down a little if that makes sense? Its...

I have a form that i have created with various tabs along the top, e.g. customer details, customer contact etc etc. I have a subform on one of the tabs. That subform also has tabs on it. When clicking on the main form tab it goes to subform but the scroll bar moves down only to show the...

I am trying to create a party booking system. I have a table for customer details and a table for requirements on a party that they book. I can obviously create one form to input data in to both tables but I am not sure how to show which party belongs to which customer. Can anyone shed some...

I would like to use several forms to help build one record in a table and I am just trying to get my head around the best way to do it. I am fairly new to access so go gentle with replies! Form 1 with ask for details about one aspect of the client such as personal details. I will then need a...

That works great, thank you. Just finally, what would the code be for it to work the opposite way around so that I could create a button to see completed tasks? Would I use 1 instead of -1?

I will try this thank you. Being a novice I am not entirely sure what should go in [NameOfStatusField] is this the name of the field the data is held in the table? The tick box uses this as the control source.

I have a tick box on the form that says completed. On opening the form with the button from a main menu if the box is ticked to say the record has been completed then it does not show those records, hence i am only working with incomplete data. I have created all of the above but am unsure how...

OK will do. So to help me in second form, what would be done to the unbound text field to ask it to calculate cost/units from a selection on a combo box please?

I did do that and it worked thank you. However, how do I get it to log the result in the table as I want to then use this data on another form without having to do the calculation again. In addition, on the new form I wanted to create a combo box to select a value and then show the result of...

Newbie to Access... I have created a form to display the information in a table and it all comes up 'fine and dandy'! Now i want to have a field on the form that calculates 2 table values... e.g. Cost price divided by units per pack purchased. (To work out cost price per unit) I am very...