Recent content by paul.brisenden

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?

Sorry Gasman, as explained before, i really am new to Access, what would my correct Criteria be? within the code above, where is the incorrect item? Thanks Gasman

To clarify. the event code remains as 1 as this is event number one, but i may have numerous different EWNs (early warning notice) for any delay to any event (an event could be delayed for multiple reasons)

the outcome selects the current record that i am working on and sends it to PDF (only the current record) the EventID is irrelevant as there are multiple events but each event has multiple NCE or EWN ID. code is below. Option Compare Database Option Explicit Private Sub...

does the same thing with both versions. sends the report to PDF and will only send the current record that i am working on. when i attempt this with other forms it send the entire list of reports found within that form. my issue is that i only wish to send the current form, to report and then to...

both version give the same outcome

Thanks for that Arnelgp, the code works fine but my issue is getting the same function to work on two other forms.

Thanks for that Arnelgp, the code works fine but my issue is getting this to work on two other forms.[/code]