[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

bound column access form

Posted on 2011-10-24
8
Medium Priority
?
350 Views
Last Modified: 2012-05-12
Hi,
attach the samplecode,
I need to fix the control inside the frmsubjectform that can update second column in the table (the text and not the number), but still leep pop-up the second frm to let me choose A1---,B1,B2,..LIST

SAMPLECBO.accdb
0
Comment
Question by:drtopserv
  • 4
  • 4
8 Comments
 
LVL 19

Expert Comment

by:MINDSUPERB
ID: 37017054
I could not find frmsubjectform of the attached db.

Ed
0
 

Author Comment

by:drtopserv
ID: 37017074
sorry, meant frmrejectsform
0
 
LVL 19

Expert Comment

by:MINDSUPERB
ID: 37017120
See attached file and check if this is what you want.

Sincerely,

Ed
SAMPLECBO.accdb
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:drtopserv
ID: 37017147
nothing new,
i need when u save the frmrejectsform , the subject field in tblrejects will have text value not number.
0
 
LVL 19

Expert Comment

by:MINDSUPERB
ID: 37017172
Have you checked the code of the after update event of the combo box? The code will set the value of the subject field based on the combo box.

Ed
0
 

Author Comment

by:drtopserv
ID: 37017330
well yes, urs works, but ur way means that i need to create another textbox that can get the update from the cbobox , is there another way that i can still keep the cbobox from having the same control source (subject) and still have the value of the column(1) -text instead of column(0) -number .
0
 
LVL 19

Accepted Solution

by:
MINDSUPERB earned 2000 total points
ID: 37017366
The data source of your frmSubjectDetails is using the value of the combo box as the criteria. With this, you could not change the Bound Column property cboSubject from 1 into 2.

I may suggest to just hide the added text box so that it will not display when you open the form.

Ed
0
 

Author Closing Comment

by:drtopserv
ID: 37017627
ic , thnx anyway:}
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In real business world data are crucial and sometimes data are shared among different information systems. Hence, an agreeable file transfer protocol need to be established.
When you discover the power of the R programming language, you are going to wonder how you ever lived without it! Learn why the language merits a place in your programming arsenal.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question