Recent content by pangeh@hotmail.co.uk

Hi, I have a form with a subform on it. The main form has the title and one control (group radio button box) that lets you choose between one of three centre. The subform lists the members of each centre and the data source is an existing query with member information. The item whose paramater...

Hi Galaxiom, Thanks for all of your help. I clearly didn't fully understand your post. After a bit of testing I found the issue was with the way I was referencing the field control on the edit record form. There was some ambiguity in my referencing. Thanks again for your explanation and...

Hi Galaxiom, Thanks for your help and reply. I tried what you said but get the same problem. For some reason when I press the button I get message popping up titled 'Enter Parameter Value' it asks me to enter a value for Student_ID. Its as if the edit record form is not accepting the...

Hi, I am using access 2003 and have a form which contains a subform showing a datasheet of a series of records. The form is like a switchboard with buttons and when you select a certain record on the datasheet and press a button it will open up another form (to edit records, delete, view...

Hi Banana, THanks for your help with this. I will definitely give this approach a go. THanks again for your time and efforts in explaining things.

Hi Banana, Thanks for your help with this. I created a standard macro (i.ee not vba code) in the access db. When the add new record form loads I have a reference to this macro to run in the onload event for each of the forms. Basically I need the student ID on the form to save to a new...

Hi, thanks for your reply. I tried the subform option. When the add new record form is opened their is a macro that moves to a new blank record. I had this same one on the subform but for some reason I kept getting an error saying that it could not ge to the last record. I have no idea...

Sorry just saw what I had done wrong, lol a typo was stopping me. Thanks in advance for your assistance.

Hi, I'm new to this forum and require some help with an access db I cant get to work. I have two different tables student records and siblings. I have an add new record fom that goes to a new blank record and when you press save it searches the latest record number then assigns a new one by...