Solved Radio Options to select a record in a continuous form (1 Viewer)

[Seph]

Good day everyone,

Just a quick one. Is there a way to select a specific record based on the selected radio button on a continuous form?

I know that the radio buttons has a different option value.

I think making them unbound is the way to go?

All I basically want to achieve is when the Radio option next to the invoice is selected, the "InvoiceID" value is captured so I can point my button "Mark as Paid" to that record.

Any ideas are appreciated.

 

[Gasman]

That is what record selectors are for, surely?

 

[MajP]

Use the forms on current event to set the value. You cannot use an unbound since all will select or unselect.

 

[Seph]

That is what record selectors are for, surely?

Thanks for your suggestion.

However they don't look very nice.

 

[Seph]

Use the forms on current event to set the value. You cannot use an unbound since all will select or unselect.

The reason I want to achieve something like this is to bulk mark desired invoices as paid

 

[Gasman]

Thanks for your suggestion.

However they don't look very nice.

View attachment 104293

Sorry, I always went for functionality first and got used to what was an Access record selector. As did my users.

 

[Seph]

Sorry, I always went for functionality first and got used to what was an Access record selector. As did my users.

no no, still appreciate the idea

 

[Eugene-LS]

Is there a way to select a specific record based on the selected radio button on a continuous form?

Maybe that would work for you?

 

[MajP]

Manipulating an independent check box field in a form

Hello! I have a form that its details is fill with fields from a query. I would like to have an independent check box field for each detail that I would like to change. I create the field in the form but when I change it on one record it chages all the records. I am thinkig to create a temporal...

www.access-programmers.co.uk

 

[Seph]

Good day again everyone, I'm attempting to implement your solutions. I'll let you know as soon as one works.

 

[Seph]

Good day again everyone, I'm attempting to implement your solutions. I'll let you know as soon as one works.

A multi select form using unbound check boxes

Thought I would put this up since it is a fairly common topic and I have put it up elsewhere - selecting records from a list for onward processing without the need for a table based tickbox. Similar in concept to the conditional formatting version I provided here...

www.access-programmers.co.uk

This solution works pretty well. Thank You @CJ_London

Only issue is, I keep getting a Runtime Error 424 after selecting a record:

 

[Gasman]

So what is GF?

 

[CJ_London]

have you created the GF textbox set to visible but top, left, width and height all set to 0

 

[CJ_London]

GF stands for 'Got Focus' - a textbox to receive the focus

 

[Seph]

have you created the GF textbox set to visible but top, left, width and height all set to 0

It was so small that I didn't see it.

Thanks again for your awesome solution and everyone for their input.

#11 was the fix

 

[Pat Hartman]

1. Creating a process like this in a multi-user environment is dangerous. Are you positive that only one person will ever be doing this at one time?
2. Updating each as it is selected required less code and is safer in the long run.

 

[Seph]

1. Creating a process like this in a multi-user environment is dangerous. Are you positive that only one person will ever be doing this at one time?
2. Updating each as it is selected required less code and is safer in the long run.

Hi @Pat Hartman, thanks for your feedback. For the most part the invoicing section will only be processed by a single user. The issue with the updating of each record individually is that its time consuming. Imaging having to click on 50 records to update them. I know as database designers we look for the most efficient way to do a task, but we must consider the user experience as well.

 

[Pat Hartman]

But, you are having to click 50 records to select them???? I don't understand the difference. Being able to use selection criteria and running an update query is probably the best solution. But, if you don't have a way of creating criteria, you're stuck with the click to select model you have.

I don't understand the manual selection at all. Normally invoicing is always a batch process. It runs on a schedule and selects all the accounts that need invoicing at that time. Without knowing anything about your business, I couldn't even begin to suggest what you might use as criteria for selection but your invoicing clerk has some way of picking. He is using some method to pick accounts. Why don't you, as a database designer, look for a way to automate the task rather than making the clerk pick 50 records manually?

 

[Gasman]

Perhaps look at it another way?
Select all within range and allow the user to deselect those that cannot be invoiced at that time?

For that reason, I believe you could have a field in the table to accomodate that, which is set at form load for those records that fit the criteria?
Clear it when invoices are processed.