database - ACCESS 2010 - Autopopulating text fields based off of two comboboxes -


i have 2 tables right now. 1 called workstations[id, workstationname, image, operating system] , other machines[id,asset tag, serial number, mac, comments]. have 2 comboboxes right now. 1 workstation table shows list of workstationname's(cboworkstationname) , other machines table shows list of assettags (cboassettags)

the goal in making form when select value in cboworkstationname, autopopulate text fields based off of workstations table, combobox cboassettags autopopulate fields related machines table based off of second combobox. in end, want able save different asset tag data workstation using drop down lists.

right now, cboworkstationname autopopulates text fields based off of workstations table , cboassettags, not populate textfields based off of machines table. however, when click asset tag (from second combobox) autopopulates related fields. it's not filling every field.

in regards how i'm autopopulating, first combobox, bound form first table, , set inherit value list yes. second combobox, set control source id. text fields below second combobox, wrote following code onchange event.

me.txtserialnumber.value = me.cboassettag.column(2) me.txtmac.value = me.cboassettag.column(3) me.txtcomments2.value = me.cboassettag.column(4)

i'm thinking have add line of code somewhere refreshes/runs second combobox when change first one.

if need clarifications please let me know.

thanks in advance!

edit:

private sub cboworkstationid_change() dim db database dim rec1 recordset dim rec2 recordset  set db = currentdb set rec1 = db.openrecordset("select * workstations id = " &     me.cboworkstationid.column(0) & "") set rec2 = db.openrecordset("select * machines id = " & me.cboassettag.column(0) & "")  me.txtcomments.value = rec1("comments") me.txtimage.value = rec1("image") me.txtoperatingsystem.value = rec1("operating system") me.txtlocation.value = rec1("location") me.txtserialnumber.value = rec2("serial number") me.txtmac.value = rec2("mac") me.txtcomments2.value = rec2("comments")   set rec1 = nothing set rec2 = nothing set db = nothing end sub

it better if used query fill textboxes. write function, , execute function in onchange event of both combo's. like:

dim db database dim rec1 recordset dim rec2 recordset  set db = currentdb set rec1 = db.openrecordset("select * workstations id = " & me.cboworkstationname.column(0) & "") set rec2 = db.openrecordset("select * machines id = " & me.cboassettags.column(0) & "")  me.txtworkstationname.value = rec1("workstationname") me.txtserialnumber.value = rec2("serial number") me.txtmac.value = rec2("mac") etc...  set rec1 = nothing set rec2 = nothing set db = nothing

you can fill in rest of fields accordingly. make sure combo's have default value, or have type of error trapping/coded default value run first time change combo.


Comments

Post a Comment

Popular posts from this blog

Android layout hidden on keyboard show -

i have strange problem layout. when tap on edittext , keyboard shown edittext stay on bottom , when tap on to hide keyboard , keyboard hides , edittext go should when want input text. when tap again, keyboard shown , edittext goes down behind keyboard... <relativelayout android:layout_width="match_parent" android:layout_height="match_parent" > <scrollview android:layout_width="match_parent" android:layout_height="fill_parent" android:above="@+id/rl_commands"> <textview android:layout_width="match_parent" android:layout_height="wrap_content"/> </scrollview> <relativelayout android:layout_width="match_parent android:layout_height="24dp" android:id="@+id/rl_commands" android:alignparentbottom="true">
Read more

google app engine - 403 Forbidden POST - Flask WTForms -

i have flask application running on google app engine. trying submit form built using wtform , keep getting following error. 403 forbidden: don't have permission access requested resource. either read-protected or not readable server. location.html (part of code) <form method=post action="/home/location"> .... <button type="submit" class="btn btn-primary" value="submit"> directions </button> </form> main.py @app.route('/home/location', methods=['post', 'get']) def location(): form = cfcdirections.direction(request.form) print(request.method) if request.method == 'post' , form.validate(): print("after if") directions = cfcdirections() street_no = directions.no street = directions.street suburb = directions.suburb postcode = directions.postcode
Read more

c - Why would PK11_GenerateRandom() return an error -8023? -

i looking through internet trying find source of pk11_generaterandom() function see why function fail. have program uses function when moved new flavor of linux, fails after forking ( fork() ) since not believe there problem nss, suspect doing incorrectly disregarded in older versions of linux new 1 there issue. the openssl package same on 'good' , 'bad' server: openssl 0.9.8e-fips-rhel5 01 jul nss rpm differs though. 'good' has nss-3.12.2.0-2.el5 and bas has version nss-3.15.3-4.el5_10 the 'good' server uses quite obsolete linux: linux 2.6.18-128.el5 #1 smp wed jan 21 08:45:05 est 2009 x86_64 x86_64 x86_64 gnu/linux enterprise linux enterprise linux server release 5.3 (carthage) red hat enterprise linux server release 5.3 (tikanga) the 'bad' server newer: linux bad 2.6.18-371.4.1.el5 #1 smp wed jan 29 11:05:49 pst 2014 x86_64 x86_64 x86_64 gnu/linux oracle linux server release 5.10 red hat enterprise linux server release
Read more