List the records in a subform through an autonumber field

[cuadradoja]

Hello...

I'd like to know how I can list the records in a subform through an autonumber field. I've tried to do it in the same way as in a main form, but it doesn't work for me. I'm really interested in learning how to use this powerful tool, but sometimes it's a bit complicated for me since I've been working with MS Access databases.

I would really appreciate if someone can help me on this particular issue.

Jose

[kev1n]

Hi Jose

I'm afraid AUTO_INCREMENT is not supported in subforms (unless it's readonly)

[cuadradoja]

Hello Kevin

I am very grateful for your answer, I had been trying to do an AUTO_INCREMENT in this type of object for some time, but now I have it clear.

I want to ask you another question... How can I make data from a main form copy to a specific field of a subform?

...and thank you very much for your willingness to help me!!!

[kev1n]

Example:

Code: Select all

// Set a cell value. If row not specified -> last row
// id: subform object id
// column: object id
// value to set
// row number

function subformSetValue(id, column, value, row) {
    if (row === undefined) {
        var r = nuSubformObject(id).rows.length - 1;
    } else {
        var r = row;
    }
    $('#' + id + nuPad3(r) + column).val(value).change();
}

// Example:
subformSetValue('your_subform_id', 'subform_column_id', object_id_on_main_form.value, 1);

PS:

It is generally not recommended to ask multiple questions in one topic because it can make it difficult for other users to understand what you are asking and to provide specific and relevant answers. Additionally, it can also make it difficult for others to follow the conversation and contribute to the discussion. It's best to create separate threads for each question, with a clear and specific title. This will help others understand what you are asking and provide better answers.

[cuadradoja]

Ok, I got it... anyway, thank you very much for the clarification and for the code. I'm going to run it in my application to see if it works for me and I'll let you know.

Regards...