Search results

Pat, hi. Good advice. I will get rid of the 0 default. In fact, I might design things very differently in future (say, using Forms and SQL to add records to my database). Anyway, thanks for the advice. I agree that PKs shouldn't have defaults - why did I do it? Don't know.... Kind...

Thank you so much. I had tried to reply to your previous post, but I used the "quick reply" feature in this forum and managed to screw up somehow. Anyway, thanks for all your help. It's gonna work now! Kindest Regards to all:):):)

That's it!! I knew it would be a fairly simple solution as my tables are pretty basic. What's the code for cancelling the save? I have the code to ensure the correct FamilyID is stored in the record. Thank you.:)

Thanks for your feedback. Always possible that design is wrong, but don't thinks so. Here's a bit more info: I've got a "family" table, with several fields, but for the purposes of this, let's say two fields, FamilyID and Name. There are 5 rows of data (FamilyID=1 is me and the others are...

Folks, hi. Hope you can help. I have a form which displays a filtered set of data based on a FamilyID field (i.e. I have a family Table and I'm displaying Tax Return data specific to a member of that family). When I click the new record button on the form, I get a blank form page, with a...

Hi folks. I'm new to this forum but have been programming for years. Got the bug 15 years ago. I live in Woking (near London) in the UK. I look forward to providing the community with some pretty tricky questions. Cheers to you all.