apologies as im still pretty much a noob.
I have a form called "Main" containg a Navigation subform. that contains a subform calle "sfrNamelist".
so on the save record button i have tried to add the requery:
Forms!Main!NavigationSubform!sfrNamelist
and i get an error.
thanks
im trying to make a list of contacts update themselves to include the new record when i add a new record.
Ive been told to use requery but i seem to be getting the code wrong as i get an error when running the macro.
the code im using in the Control Name field on the macro screen is...
i'm using the web contacts template and attempting to recreate its processes for my own needs.
i notice that when using the original and adding a new contact, the namelist area updates as soon as i close the data entry form (called ContactDetails) on the template.
On my recreation i have to...
guys, thanks for the quick replies.
just to clarify i have a text box on a form. I'm using expression builder on the control source.
I tried what bob said but it brings an error about not being compatible with web based forms.
any ideas how i can get round this?
I've created a text box in a form where i want to to show show all my address fields like this:
address 1
address 2
City
Post code
i dont know how to start a new line so the best i can get is:
address 1, address 2, City, Postcode.
this is the code i used:
=IIf(IsNull([Address...