Recent content by badz2801

Thank you. Nope not too basic I had no idea you could do that. This is my third day of using access in this manor. Just got lucky that database design is similar in MySQL. Thanks again Ian

Thank you I cannot locate an on activate tab. Which form does this code go into? What control? The combo box?

Here is the database as I have it thus far.

Update Hello I just tested the form a little more and I am experiencing the following additional issues: 1. When I delete all the records, it wont allow me to delete the very last (or newest in this case). 2. I have a text box near the combo box which displays the job number selected in the...

Hello I am having a problem deleting the last record from a form in my database. My database is setup with a one-to-many relationship. Main table: Autonumber JobID JobDetails table: Autonumber JobID ToShop Submitted Etc....etc. The form uses a combo box to select the job and displays the...

Lightray - your idea worked like a charm. Thank you for your help, im new to access so I had no idea you could do that. CEH - I read a few articles on normalization, im not sure that I have violated the rules. I checked my database against several microsoft designed access templates and the...

Hello I am trying to setup a simple database with forms. Currently I believe my database is correctly designed however I am having trouble getting data displayed correctly on the form. My database has the following structure: Parent table: Job Column 1: JobID - primary key, autonumber...