Cannot add new records on forms

[Dave14867]

I cannot determine what is wrong and/or how to fix the issue with not being able to enter new data into forms. I think I have somewhat of an understanding as to why, but I don't know how to resolve it.


This is really giving me a brain cramp, I have designed several databases before and they are working great, it is just this one I cannot get resolved.

If you open the attached file and open the frmSpecies and try to enter something that isn't in the drop down it won't let you, the same with the frmBreed. I can enter the data in the associated tables with no problem.




Issue-File.zip



Thanks in advance
Dave

[Minty]

Why are you using a combo control on the data entry form for the table the drop down is based on - it makes no sense to do so really.

Think about it - the only use for the form is to maintain or add new species.
By definition if you need to edit the name or add another one it won't be in your combo list, and you have set the combo to limit to list. So it's self defeating.

I can see the point for the related data that is drawn from other tables, but not the actual Primary (unique?) Description.

[Dave14867]

Minty,

I took it from the parent form, but thinking about it there is no reason to have a combo for the primary field but I believe it does make sense for the secondary field. Take the Breed for instance, the combo for the species makes sense to me.

Is that what is causing the issue?

Dave

[Dave14867]

Minty,

Thanks for the whack up side the head. I don't know what I was thinking, I guess I just was thinking so much about combo boxes I just put them in on those form also.

I replaced them with regular text boxes and it works fine now.

Thanks

Dave

[Minty]

Glad you are fixed

Sometimes the wood and the trees just get in the way.
Good luck with the rest of your project!