Form + Subform = :(

[Mattymatt79]

ok,
i have these forms where the users enter information into it. That works fine
but at the bottom of it it has an update record subform that the user enters information when it was last changed

the subform will let me enter in ONE update but after that it wont let me do a dang thing so im pretty much screwed

the subform is a table which is
autonum
date
name
type
remarks

the form is a table
and it is linked appropriatly
i linked the child and master forms in the tables but it just keeps giving me errors when i try to add another update
im pulling out my already short hair with this

also
the entire database is pretty much set up like this
main form
sub form when it was last updated
unless i should just scratch the subform idea and just make it another item on the table itself but then i think id be ruining something

 

[Mattymatt79]

its like this
there are 5 units
all 5 have different things
the child thing and whatnot lets me make changes to the thing which is cool
but it makes them for all of them
i want it to be different for each one
like
11 has different info then say 13 and i need the update part to reflect that
i have no idea what im doing wrong here, just the fact that i am doing something wrong

 

[The_Doc_Man]

The issue is difficult to analyze from what you said. I'm going to take a guess (not a detailed analysis).

One possible reason you can't do a second update would be the relationship between the parent and child tables. If this is not one (parent) to many (child) then one update would be your limit.

Also, your supplemental information suggests that you have 5 things you could store. But another part of your problem shows only one child table. So where the 5 comes in remains a mystery.

If your subform has full navigational controls on it, you should be able to see the "add record" button (looks like a triangle pointing to an asterisk to the right of that triangle.) If clicking that button doesn't allow you to add a record AND doesn't give you an error message, I'd worry about having incorrectly specified the linkage between parent and child.