You're trying to put an autonumber type (long integer) into a text field, which is probably the problem you're having.
You can put this in the OnOpen event of form2, it'll convert the autonumber to text (string)...
Me!InspectionID = Str(Forms!Form1!InspectionID)
Edit: You mentioned you're new to access...and this scenario sounds like you may not have a good table/relationship structure. Normally you wouldn't store redundant data in 2 tables. There's about a billion posts here on normalization. Or if InspectionID in Form2 is a foreign key, consider changing the data type to long integer. Sorry if I'm off base here.
Last edited by cpgospi; 02-11-05 at 11:28.
thanks for the response and I will try this, most likely this afternoon. Also, I am new but do understand what you are saying. Unfortunately, I am working with a DB that was created by someone else and has a lot of data already in it. I am trying to fix things quickly with what I have to work with. I may end up starting from scratch, doing things correctly though if I can't get beyond some of these problems I keep encountering.
Again, thanks for your help. I'll respond with the results.
Hi Landon and "Welcome to the Forum"
Reading your situation may I quickly advise you that you should look into getting your database in the proper order as fast and as correctly as possible. The longer you wait, the more data you collect, the more problems you will soon have to try to work your way out of. Just for the sake of getting some practice in, go ahead and create you a new well structured database with a well laid out and planned for the future structure. Then you might be able to Import the data from the Tables you have already, (after picking them apart to fit into your new one). It might take a bit of doing, but I think you'll be better off in the long run. Friendly advise from another forum poster.