Recent content by Raystorm

OK, sorry for any confusion! OK, when I go to an existing record, I can't enter any data into fields that are in a linked table. I get the error message that I mentioned in the first post, and when I close the form, I get the error message 'You cannot add or change a record because a related...

Hi All, I've got a form that uses a query to the tables in my database as it's record source, and I've got a problem. Basically, when I'm entering a new record, I can enter data into fields from all of the tables with no problems. However, if I go back and edit an existing record, then Access...

Thank you Bob, I'll try building a query tomorrow and then building a form around that and see how I get on. I've looked at some forms in other databases that work in the way that I want, and they work in this way.

Thanks Bob, so just to be clear, the steps would be 1. Create Query with all the fields that I want to show in the form in 2. Point a form at that query?

Thank you Bob, I take it that this query would go in the Record Source property of the form? However, the form I'm using takes data from a number of different tables. Would this affect any of the other fields in the form?

Ah, I see now. I think perhaps that I'm approaching this the wrong way. I've used forms in the past that allow you to use the navigation buttons to go backwards and forwards through the records in the database, and also add new records via the form. How would I go about doing this? Would I...

Hi, sorry for not being clear enough! I'm using the form in Data Entry mode. I've now changed Data Entry to NO, but the problem is still there. How would I go about making the nav tools show the number of records in the underlying table rather than the current recordset?

OK, I've set Data Entry to YES now, but it's still showing 1 of 1 record when I've got around 10 records in the database.

Hi all, I've got a problem with a form that I've created. If I enter data into it, the record counter with the navigation buttons reflects the number of records in the database. However, if I close the form and re-open it, the record counter resets itself to record 1 of 1 again. However, the...