Using the option button or check box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a DB that has a table with multiple errors, meaning: Loan #, error1, error2, etc (fields). I want to be able to create a form using this table and make the error (field) either option or check box. Now based on the error # they check off, it will let me know if that loan # with that error # was completed. Can someone please help me with this code. I have the form already completed. Just need assistance with the code recognizing the text field as a option or check box

Thanks
 
Mac

If you "have the form already completed", your best option may be to start
over...

Having multiple, repeating fields (error1, error2, ...) may be the only way
you can set up your data ... in Excel. Is there a reason you aren't using
Excel?

Access is a relational database, and what you are trying to do is relatively
simple, but only if you've set up your data relationally. Among other
things, this would mean an underlying table structure that does NOT have
repeating groups.

Here's another approach -- a table with two columns (this is for
illustrative purposes only - your table would need one or two more fields
for DateOfError, or other such...):

Loan#
ErrorCode

Now, with any Loan#, you can return as many rows as there are errors for
that Loan#. You don't have to build code to search across columns, count
the number of filled columns, ... etc.
 
Mac

I'm having trouble visualizing your setup.

Are you saying that the only way you can see the data (or store it) is with
repeating fields?
 
Example: Table1 consist of Error# and Desc
Table2 consist of Loan #,SVC Loan #, Error1, Error2, Error3, et
Created a form with tbl1 as combo and tbl2 as subform, which is fin

Now they would like to see Error1, Error2, etc as an option button on a different form so when they pull by loan # and select one of those errors, it tells them whether it has been completed and update date. How is that
 
Mac

It sounds as if you have decided that your current table structure is fixed,
and you want to find a way to make Access work around that design.

I really don't have any experience in your situation. If you want to
consider designing your tables more relationally, and less like a
spreadsheet, post to the tablesdbdesign newsgroup.

Perhaps one of the other readers can offer a way to do what you are
asking...
 
Back
Top