Add/Edit/Update record using Form, please help.

[isabel2005]

Hi,

I want to be able to add/edit/update record into the tblMember using Form. How do I do that? I created a relationship between this table already.

I just need to know how to add the record into the tblMember table.

Any assistance is greatly appreciated as I'm a newbie.

Thanks in advance,
Isabel

 

[harleyskater]

HIii I think I did what you wanted I am attaching it. you are the first person I did this for : 0 so if I helped add to my rep, if you have more questions then ask away

 

[isabel2005]

Hi there,

Thank you for the quick reply. I love the form you made.

However, I wanted to be able to select the dropdown list of primary and second language and add the record to the tblMember table.

I attached the file again with the Form "addMember". It has dropdown list of language but it doesn't work as I don't know how to store these info into the tblMember table.

Ultimately, I will want to be able to update the record, like if I make mistake on second language or something, I can go back and update it.

Thanks,
Isabel

 

[harleyskater]

haha ok : ) promise me some rep and I'll get it done : )! be right back with the finished product : )

Hi there,

Thank you for the quick reply. I love the form you made.

However, I wanted to be able to select the dropdown list of primary and second language and add the record to the tblMember table.

I attached the file again with the Form "addMember". It has dropdown list of language but it doesn't work as I don't know how to store these info into the tblMember table.

Ultimately, I will want to be able to update the record, like if I make mistake on second language or something, I can go back and update it.

Thanks,
Isabel

 

[harleyskater]

here it is : ) I used "Distinct" SQL statements to build the rowsource for the dropdown combobox

 

[isabel2005]

nooooo... I won't promise

Can you please look at the frmMember in the Form tab? It displayed the language name and not the ID.

With the one you created, it showed the ID. I don't want the ID because I won't be able to know which languages once I add more records.

Thanks,
Isabel

 

[isabel2005]

Hi there,

I managed to figure out how to add the record.

This is how I wanted. (see attachment)

Thanks again for your help.
Isabel

 

[harleyskater]

Hi I am back at work : ) So you have it undercontrol now? : ) : )
No prob

Hi there,

I managed to figure out how to add the record.

This is how I wanted. (see attachment)

Thanks again for your help.
Isabel

 

[AccessInitiate]

In need of your assistance

Hi guys!

I'm also new at this and seeing the database that was used here was very helpful; It has same concept that I wanted to implement as well! But I don't understand how you were able to update specific fields in the table through the form. I didn't see any visual basic coding in the event section of the properties. Can you please explain it to me? I would also like to update a specific field through a form, but more of a date checked-out/date checked-in type of function.

Thanks!
Jeremy