Recent content by Kubalism

Would anyone know the solution of this problem? Because until I know I can't fix it. Please anyone,

So it is a possible that if i use a vba code and make a sequence like, setfocus and save subform 1, subform 2 and so on? same goes to the delete? Because if it is possible, the advice given by vbaInet is what I am going to do.

Is it possible to setfocus to multiple subforms? Does that make sense?

That I would need to know how.

Command works on deleting entries on the form but not deleting the entries on my table (tblWitness,tblEmployeeInfo) Thanks Edit: Problem now it is duplicating the items on my dropdown list. Ref_Accident_typesAccidentTypeDescriptionViolation Against Proper Conduct and Decorum, Persons and...

First problem solved. But it adding another field on the table which isnt supposed to happen. Additional question,, How do I delete data on a table while I am on a form ? :)

@ Isskint is this what you are asking for ? SELECT [Ref_Accident_types].[AccidentTypeID], [Ref_Accident_types].[AccidentTypeDescription] FROM Ref_Accident_types ORDER BY [AccidentTypeDescription]; @boblarson I didn't use a lookup wizard on table form. What I did is I used the Combo Box...

Thanks for the swift reply sir. 0";1" - I have this in the column width. I would change this to what to all combo boxes?

What width would be 0? My dropdown box width? I don't undersrand. Please explain further.

Hi, I have 3 tables(Ref_Accident_Status, Ref_Accident_Type, Ref_Seriousness). On my main form, I created 3 combo box and choosing the above tables as my source. But after I click save and close the form, re open the form it shows numbers on the dropdown list. why is that happening?

Bumping on this. Please someone take a look at the code.

I'll try to see what I can do. Because I really have little experience about macros and VB. EDIT: I still can't make it work. Adding the navigation button is the easiest way but clicking save and new record button for like 4-5 times is really inconvenient. I tried this code, but it only...

Oh no no. It's just a sample database that I've downloaded. That isn't my database.

Yeah all the forms are bound. Here is an example of what I am trying to explain. Please see attached pictures.

The CompanyID is not an autonumber. It is there so that I can input a unique DXXXX format for each employee. Adding the navigation button will save. But is there no way of adding a single button which will save all entries from the 3subforms at the same time?