combo box and delete record button not working properly

[joepet]

Hi all,

there're two main problems I can't solve because of limited knowledge of access:
* Delete button in Form1 doesn't work, my main goal is that it would delete employee record and all related records in related tables.
* After selecting employee name in combo box, related info does not appear in the form (no result).

Can anybody comment why this problem exist and suggest probable solution.

Thank You in advance



P.s. database is attached

[RuralGuy]

Do you need to stick to Macro's or will Code work for you?

[orange]

Can anybody comment why this problem exist and suggest probable solution.

I don't see a DELETE button. And as Allan said, since this is your first post do you have to use macros?

For a first project, I would recommend you use a naming convention that does NOT allow embedded spaces (or special characters) in field or table names. It will save you a lot of frustration with syntax issues in future.
I would also stay away from MultiValue fields, Attachments etc until I was comfortable with table design and relationships.
I would suggest using vba vs macros, just because of the availability of help for same on the forum.

In general I would work from very simple to more complex. For example, a single table, a single form, with a single button - if all the button click did was display a message -great. Then move to something more sophisticated.

There are a number of youtube tutorials that can help.
Also there are a number of video tutorials at http://www.datapigtechnologies.com/AccessMain.htm

Again, these are recommendations - use them if you wish.
Good luck.

[RuralGuy]

Your Delete button is just deleting the current record from the Trainnings table. In order to achieve what you stated you would need to delete the Employment Info record.

[joepet]

thanks for reply, is there something you noticed wrong with relationships is set up?

[joepet]

I don't see a DELETE button. And as Allan said, since this is your first post do you have to use macros?

For a first project, I would recommend you use a naming convention that does NOT allow embedded spaces (or special characters) in field or table names. It will save you a lot of frustration with syntax issues in future.
I would also stay away from MultiValue fields, Attachments etc until I was comfortable with table design and relationships.
I would suggest using vba vs macros, just because of the availability of help for same on the forum.

In general I would work from very simple to more complex. For example, a single table, a single form, with a single button - if all the button click did was display a message -great. Then move to something more sophisticated.

There are a number of youtube tutorials that can help.
Also there are a number of video tutorials at http://www.datapigtechnologies.com/AccessMain.htm

Again, these are recommendations - use them if you wish.
Good luck.

thanks for reply, is there something you noticed wrong with relationships is set up?

[RuralGuy]

I don't see anything wrong with your relationships.

[RuralGuy]

When your form displays a 1:M record, why would you expect it to delete the 1 side rather than the Many side?

[joepet]

When your form displays a 1:M record, why would you expect it to delete the 1 side rather than the Many side?

Regarding macros - no, i do not necessarely need to stick to them, I just proceeded the way I knew. I found VBA code sample for deleterecord and copied it to my database (sample attached), however as previous times it just clears the contents from form, but records in table are not touched...

[RuralGuy]

Try this db.

[joepet]

Try this db.

RuralGuy,

it works perfectly so far, thanks a lot! So was the problem in my case that integrated button with wizzard was not linked to correct table and where it was linked?

[RuralGuy]

The answer to your question is in my post #8.