Basic, easy questions (probably)

[Chaotix]

Ok, this is probably going to sound REAL stupid, but I'm an ASP developer, and not used to using interfaces for my data access pages. My question:
How do I make what the user selects on a form to be entered into the database? In ASP, I would use form submission logic, but this user interface thing is confusing. I have a basic form (with a subform) and would like the entries to be saved, deleted, etc. Also, my subform appends a blank entry to the end of it whenever I enter in a new value, which is cool, but the entries don't get saved into the database. Thanks for any help you might offer to a "silly newbie". hehe

~~Chaotix

 

[wh00t]

well, I dont know a great deal about asp, but am learning.

you could check out http://forum.snitz.com/ and download this (it is free)
this is an ASP forum that stores the information in an Access db, go through the codes provided, they may help

 

[Chaotix]

No, not ASP

Well, I wasn't requesting info on ASP (I pretty much have that side of things covered, as I have been developing with it for about 4 years now), rather I need help with Access Forms. They are new to me. Since the post, I have found that I _can_ edit the values on RECORD 1, but when I click the "next record" button at the bottom, I can't enter anything into the fields. It just won't let me. I got the info into record1 by manually typing them into the tables (as a test). How do I go about make it so that I can add records? thanks.

~~Chaotix

 

[KelMcc]

I don't see the "next record" button on the .gif you provided, but in the form properties under data, look for some criteria, like allow additions, allow edits, allow deletions... These should be checked "yes". They generally are by default, so I doubt that's your problem. If they are checked "yes", Access should accept your data.

Also, are your combo boxes bound? If they're bound, they're linked to the field you want your data to go to.

I hope his was helpful...

 

[Chaotix]

Yes, my screenshot doesn't include the next record/prev record buttons, so I attached the full form below. When I click on the "next record" button, I can't enter in any values. It's like they're locked or something, but in the form properties, Allow: Filters, Edits, Deletions, and Additions are set to "Yes". Data Entry is set to "No", though. But, if I set Data Entry to "Yes" then I can't even edit the existing record (record1)!!! I have also included my database structure (next message) for your enjoyment.
thanks again for your help!!
PS - is there a good tutorial or FAQ that I can look at to figure out how to do updates, deletions, etc or should all of that stuff be handled "automatically" by forms?
~~Chaotix

 

[Chaotix]

Database Structure

simple, eh?
EDIT: I created the form by using the wizard, by the way.

Thanks
~~Chaotix