Recent content by paul.brisenden

i can only assume that it was carved into stone tablets

Royal Dutch Shell (Shell petrol) use a huge amount of freelance IT staff, i only know this as my wife is a Programme manager for Shell Retail IT.

database is attached if anyone does have 5 minutes to show me where im going wrong. in a nutshell. i have a form called RESPONSES, within the form (and table) i have a YES/NO selection. i have created a query that i thought would work (called responses query) im looking to display a list...

i have a Project ID number that links both the subform and the main form. The relationship is set up and working. I have selected the items from the table that i want to display within the query and added "no" within criteria of the field that contains Yes or No. however, the subform that...

Guys, i have a subform displayed on a main form that i wish to show every record that has a "NO" response to a question. could someone step by step the query for me at all please?

Yes. No matter what parent form i am in i only have the option to scroll down to two records. to be fair its not too much of a problem, however it is bugging me as to why other subforms are working no problem when they were created in the same way.

Any idea why my continuous forms stops at 2 records? i have a form with various subforms within, 3 of my subforms scroll down to record as many records as i need. however ONE subform will only allow for 2 records?

solved it. Thanks for the input though.

SOLVED - there was a hidden Query that i didnt realise i had

attached below select VIEW ALL EVENTS. click Event ID PMI

its a local table

Attempted to manually type the control name - Not working. Table has new entry PMI price box with manually typed control source not working control source is not showing updated table field.

Table is already linked to a form and all boxes in form are bound by control source. Added a new column within the table and set the format. opened form in Design view and added a new box attempted to bound the box in the control source selector new table column not visible within control...

Hi Guys Ive added a new column in a table but this is not showing within the control source selection. Am i missing something?

That you for that GP George, sorry to ask but where in the second line would i place the filter?